Forum

These lines of code are made inactive as you have them commented out. Remove the single quote from the front of each of the lines of code. 'S...

Look at this link Also if you google :Excel Templates for Amortization with changing rates there are multiple resources

If I understood you correctly, I first grouped your table by Personal Reference and Max Date. I then merged (joined) that table back onto the origina...

Will be easier to provide a solution if you provide a sample worksheet and a mocked up solution of what you desire. 8-10 records should be sufficient...

I would use a different approach. With Power Pivot, build a measure to concatenate the values. ie. =CONCATENATEX(Range,Range[Name],", ") ...

I am a bit confused as to what you want the end result to look like. Please mock up a solution so we have a better idea.

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-->