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

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

That's certainly possible, but without more details it's hard to tell you how
to do it.

On Tue, 12 Oct 2004 11:38:13 -0500, ShadowAce
wrote:


I am working on a project that takes a raw data file and generates
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 in
another worksheet, and I would like to dynamically add data based on the
names in the pivot table. The number of names in the pivot is dynamic
as the data files are of different sizes.

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

Is this possible in Excel?

ShadowAce