Condensing a large data dump
 

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?

It would be difficult to imagine what role a SUMIF would play if you have a
pivot table. The pivot table should provide most of the summary
information.

In any event

select your row label area (the rectangular area that contains both the
cells you want to file in and the cells that would determine what value they
would contain) and run a macro like:

Sub AB()
Dim rng as Range
set rng = selection.Specialcells(xlBlanks)
rng.Formula = "=" & rng(1).offset(-1,0).Address(0,0)
selection.Formulas = selection.Values
End Sub

--
Regards,
Tom Ogilvy


"Ant" wrote in message
...
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?