I'm like to create a function to sum data from worksheets that have yet to be
created. I'm attempting to automate the import of new data into new
worksheets. I have considered creating hidden worksheets and ensuring that
the new worksheets are always between the hidden worksheets. I could then set
the range for the function to be the same range on the hidden worksheets and
everything between? Is there a better/simpler way to accomplish this? Thanks!

"I'm like to create a function to sum data from worksheets that have yet to be
created."

Where are the data to be summed if the worksheet that will(?) contain them
hasn't been created.

Mike

"tpmax" wrote:

I'm attempting to automate the import of new data into new
worksheets. I have considered creating hidden worksheets and ensuring that
the new worksheets are always between the hidden worksheets. I could then set
the range for the function to be the same range on the hidden worksheets and
everything between? Is there a better/simpler way to accomplish this? Thanks!

I have a summary worksheet on which I'd like to insert the functions. The
data that I will sum has yet to be created. Essentially it's a template that
will be populated with the summary data as it is created.


"Mike H" wrote:

"I'm like to create a function to sum data from worksheets that have yet to be
created."

Where are the data to be summed if the worksheet that will(?) contain them
hasn't been created.

Mike

"tpmax" wrote:

I'm attempting to automate the import of new data into new
worksheets. I have considered creating hidden worksheets and ensuring that
the new worksheets are always between the hidden worksheets. I could then set
the range for the function to be the same range on the hidden worksheets and
everything between? Is there a better/simpler way to accomplish this? Thanks!

Insert a new blank worksheet at beginning...........name it Start

Insert a new blank worksheet at end.............name it End

You can hide if you wish.

Your 3-D formulas will be something like

=SUM(Start:End!A12)

When adding sheets insert them between Start and End


Gord Dibben MS Excel MVP


On Mon, 25 Jun 2007 11:03:01 -0700, tpmax
wrote:

I'm like to create a function to sum data from worksheets that have yet to be
created. I'm attempting to automate the import of new data into new
worksheets. I have considered creating hidden worksheets and ensuring that
the new worksheets are always between the hidden worksheets. I could then set
the range for the function to be the same range on the hidden worksheets and
everything between? Is there a better/simpler way to accomplish this? Thanks!