-I'm not sure I can visualize your layout. Are you saying you want
74x3 area
for each name, with the macro to get the names from the pivot table an
some
other data from the raw data sheet?-

Yes. The third worksheet contains the processed data for eac
name--Each name has a table that is 3 cols x 74 rows.

I want to dynamicallu produce each 74x3 table depending on the numbe
of names in the pivot table, where the number of names is also dynamic

--
ShadowAc
-----------------------------------------------------------------------
ShadowAce's Profile: http://www.excelforum.com/member.php...fo&userid=1522
View this thread: http://www.excelforum.com/showthread.php?threadid=26855