I am not sure if VBA is the correct approach but I need something that is repeatable and can be run with a simple press of a button, Unfortunately I am a complete noob to VBA so any assistance would be appreciated.
We have a growing currently 5000+ rows CSV file that is produced from our quotation system, and this is growing on a daily/monthly basis
To make the data useful the values need to be summarised so that there is just one record (row) per unique quotation no, that contains all the row data, but with the value totalled for all the matching items.
I have tried using Pivot tables and looking at other solutions on this Forum, but don't know enough to work out how to change the macros I have found to work with our data.
I have attached a very small sample spreadsheet with the core data, and any help would be much appreciated
Andy
PS Moderators this is my first post after trawling through this forum and hopfully this message abides by the rules
Bookmarks