I am working on a project that takes a raw data file and generate
reports from it, based on a column in the file that contains a name.

I import the raw data into a worksheet, I have created a pivot table i
another worksheet, and I would like to dynamically add data based on th
names in the pivot table. The number of names in the pivot is dynami
as the data files are of different sizes.

So I have an area in the third worksheet with 3 columns of 74 rows, al
calculating its data based on the raw data in worksheet one and the nam
in the pivot table. I would then like to re-create the same area base
on each name in the pivot table with a column or two separating eac
name.

Is this possible in Excel?

ShadowAc

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