Dynamically generated content

  • Thread starter Thread starter ShadowAce
  • Start date Start date
S

ShadowAce

-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
 
OK, but help with a macro requires lots more information. Some examples:

1. the location and specific layout of the pivot table (e.g. are the names a
row field or column field?)
2. what specific data is to be retrieved from the raw data sheet
2a. where is it, or
2b. how do you locate it
3. in which row and column is it supposed to go on the 3rd sheet.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamically generated content 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Pivot Table..getting a list of all, sourec odata and sheets locate 4
Dynamically generated content 4
Playing back a Pivot Table macros 2
Copy PIVOT table? 5
pivot table 1
Complex Pivot table formatting 2

Back
Top