I have a large SAP data dump (approx 17,000 rows each month) which I would
like to condense into a form where I can use a SUMIF function to pick up
various data. nb. the reason I need to condense the initial data dump is that
it becomes way too large to manage and stalls my machine. Currently I can do
it by creating a pivot table which I then copy and paste as values then copy
down each section to the next one to form a full range of data that a SUMIF
can recognise. This usually ends up around 300 rows. Is there some way I can
either run a macro to fill out the sections of the pivot table or is there
something more advanced technique that can create the condensed version?