Add Complex Worksheet programatticaly

[Aaron]

I have a complex excel workbook. It is about 4 MB if that means anything.

There is a data entry worksheet with 10 columns. They correspond to 10
subsequent worksheets that use the data from one column to calculate data.
The data produced is in multiple columns and covers 40 to 100 rows. Each
row's data is for a specific year.

A worksheet aggregates the data from the 10 sheets by checking the year of
each row in the 10 sheets and pulling the matching year's data together into
one row. There is a row for all applicable years. There are very complex if
then and sumif statements that pull it all together. This date is then
analyzed and goes into tables and graphs for proposal and reporting purposes.

Here is the question. How could I set it up to add additional worksheets
that would point to an additional column in the data entry page and be
included in the data aggregation page?

 

[John W. Vinson]

I have a complex excel workbook. It is about 4 MB if that means anything.

There is a data entry worksheet with 10 columns. They correspond to 10
subsequent worksheets that use the data from one column to calculate data.
The data produced is in multiple columns and covers 40 to 100 rows. Each
row's data is for a specific year.

A worksheet aggregates the data from the 10 sheets by checking the year of
each row in the 10 sheets and pulling the matching year's data together into
one row. There is a row for all applicable years. There are very complex if
then and sumif statements that pull it all together. This date is then
analyzed and goes into tables and graphs for proposal and reporting purposes.

Here is the question. How could I set it up to add additional worksheets
that would point to an additional column in the data entry page and be
included in the data aggregation page?

Please repost your question in an Excel newsgroup. You'll get more expert
advice for this Excel question than the Access folks here are likely to have.