If the list already exceeds 64K rows then it must be in a database or
maybe even a simple text file. Either could be attached to directly by
the pivot table using the 'external data' option when creating the
pivot table.

If you have to have all the data in 2 or more worksheets you could use
a union command in MSQuery.


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=557903