Dynamically generated content

[ShadowAce]

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

 

[Myrna Larson]

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.