Last seen: Jun 13, 2025
crossposted: Please read:
Is it possible that the path names and directories on the new laptop are not exactly the same as on the older computer?
While Riny has provided a formula solution, you could also achieve similar results by combining (concatenating) the columns with a delimiter such as ...
No file attached. Please try again.
You have not provided any Order IDs in your DB. Without this information, a lookup via a parameter query is not possible.
If I am understanding your needs correctly, then an easy means is with Power Query versus VBA Mcode let Source = Excel.CurrentWorkbook(){[N...
Would be very helpful if you attached (uploaded) a sample file with 8-10 records showing what your file looks like when it has been downloaded from th...
With your table let Source = Excel.CurrentWorkbook(){[Name="Tbl_1"]}[Content], #"Filtered Rows" = Table.SelectRows(Source, each [Employee...
crossposted: Please read-->
crossposted: Please read:
Using just native Excel features, you could select filter on the Data Tab and unselect blanks.
Suggest you upload a sample file showing your source values and a mocked up solution so we have a solid idea of your needs. Do not upload a picture a...
If your data is in its final presentation mode and you do not need to maintain formulas in the output, then I would recommend using Power Query to rea...
Deidre Taking another approach, please attach a sample excel sheet and a sample access workbook showing your issue. Tell us exactly how you take t...
maybe attached