how to pull data from a specific cell on each tab as I add tabs

E

egljet1

I routinely pull data from an increasing number of tabs in a worksheet. Is
there a way to pull the data from tabs as I add them without having to change
the formula for each added tab?
 
S

Shane Devenshire

Hi,

If you are using a formula of the form:

=SUM(Sheet1:Sheet4!A1)

which sums cell A1 in all the sheets physically between Sheet1 and Sheet4
then when you want to add a new sheet and have the formula pick it up, insert
the sheet between the beginning and end sheets.

If you can't do that then insert a blank sheet at the end so that in my
formula Sheet4 is blank, then insert the new sheet before sheet4.

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 

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

Top