Function to incorporate worksheets that have yet to be created?

[Guest]

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!

 

[Guest]

"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

 

[Guest]

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.

 

[Gord Dibben]

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