Pivot Tables

V

Vicki

I have a workbook with multiple worksheets that contain
pivot tables which I have named. I want to add selected
pivot tables to a new worksheet. Is there a way to create a
link without cutting and paste special, link?

Thanks
 
J

JE McGimpsey

Vicki said:
I have a workbook with multiple worksheets that contain
pivot tables which I have named. I want to add selected
pivot tables to a new worksheet. Is there a way to create a
link without cutting and paste special, link?
Click to expand...

I'm getting stuck on the part where you've named your pivot tables. Do
you mean that you've named the range that the pivot table resides in?

In that case you may be able to use the INDEX() property.

Say your 1st pivot table is named "table1" and you want to put it into a
new sheet in the same workbook. You can enter:

A1: =INDEX(table1,ROW(),COLUMN())

Copy down and across.

If you want the new table to start on E3, say, subtract constants from
ROW() and COLUMN() to suit, e.g.:

E3: =INDEX(table1,ROW()-2,COLUMN()-4)
 
Top