I have a spreadsheet which I get on a daily basis.
This spreadsheet has a list of accounts, currencies and values.
Basically I want to create a summary on the Summary sheet, which lists all combinations of accounts, currencies and the sum of the value.
I know I could achieve this via a pivot table, however, was wondering how I would achieve the attached example summary sheet by VBA code?
Some days I might only have one account. Other days I may have hundreds. The same applies to currencies.
Thanks in advance
Bookmarks