I have a huge (30MB) pivot table with lots of market data. However, I need
to pull this into Access in order to really crunch the data properly.

The data looks like this:

Region Vendor Product shipped units, etc.

Currently the pivot table shows "USA" for the region once, then the Vendor
name once, etc. so that when I pull it into Access, all I have is one row
with all of the data.

I would like to either output a pivot table where every single cell is
populated or create a macro that goes down a column, and if the cell is
empty, copies the value of the cell above; if the cell is populated, it skips
down to the next cell without doing anything.

I do not have access to the source information, only the pivot table.

What I do is recreate the pivot table using a formula such as...
If(len(A2)=0,A1,A2)
and copy that logic all the way down the rows and across the appropriate #
of columns. Then I PasteValue it.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"JSF" wrote:

I have a huge (30MB) pivot table with lots of market data. However, I need
to pull this into Access in order to really crunch the data properly.

The data looks like this:

Region Vendor Product shipped units, etc.

Currently the pivot table shows "USA" for the region once, then the Vendor
name once, etc. so that when I pull it into Access, all I have is one row
with all of the data.

I would like to either output a pivot table where every single cell is
populated or create a macro that goes down a column, and if the cell is
empty, copies the value of the cell above; if the cell is populated, it skips
down to the next cell without doing anything.

I do not have access to the source information, only the pivot table.

You may be able to extract the data by double-clicking on the grand
total cell in the pivot table.

JSF wrote:
I have a huge (30MB) pivot table with lots of market data. However, I need
to pull this into Access in order to really crunch the data properly.

The data looks like this:

Region Vendor Product shipped units, etc.

Currently the pivot table shows "USA" for the region once, then the Vendor
name once, etc. so that when I pull it into Access, all I have is one row
with all of the data.

I would like to either output a pivot table where every single cell is
populated or create a macro that goes down a column, and if the cell is
empty, copies the value of the cell above; if the cell is populated, it skips
down to the next cell without doing anything.

I do not have access to the source information, only the pivot table.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html