I have 25 pivot tables on one worksheet each one of which is placed just
one row below the previous one.

I'd like to seperate them with empty space by making each one start on
the thousand'th row. That is, the first would be on row 1, the second
on row 1,001, etc and the last one on row 25,001. That way I can
always add more data to the original data set and expand the pivot
tables without risking them overlapping with each other (which is a
no-no). Is there a way to tell excel to insert, for example, 937 empty
rows between two existing rows? Otherwise I will have to keep inserting
by trial and error (25 times) until I hit the target row.


--
cwinters
------------------------------------------------------------------------
cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386
View this thread: http://www.excelforum.com/showthread...hreadid=376840