link formulas sheet 1 to same cells for sheet 1,2,3 etc

[Vic]

my workbook consist of 10 one year expense tabs 2009 thru 2019 and a summary
tab.
i want the summary tab to tally the calender year expense as i copy the
summary tab from year to year. Every year tab uses the exact same cell from
year to year. the only difference is the the tab 2009, 2010, 2011, etc

 

[Mike H]

Hi,

This assumes the first sheet is 2009 and the last 2019 and all the other
sheet are between those 2 sheets

= SUM('2009:2019'!A1)

Mike

 

[Vic]

Thank but thats not it. ok lets try to explain. 2009 tab is a running expense
for the year. it configure column a date 1/1 thru 12/31. each month has 5
catogories from columns D-H and Columns M-Q each of these columns has a
monthly total. i have created a separate summary tab which separates these
columns and import the monthly totals. (='2009'!G34) i would like to copy
this summary tab in front of each year and only have the 2009 in the formulas
change to ='2010'!G34,='2011'!G34 etc. can this be done without manual entry
for each year?

 

[Ashish Mathur]

Hi,

You can use the following formula and copy down. A3:A13 has 2009 to 2019

=INDIRECT("'"&A3&"'!G34")

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Vic]

i dont see how this will link the year tabs to the summary tab. each year is
its own tab. my summary tab import the monthly total from the 2009 tab/
worksheet only.
so my workbook is as follows: table, summary, 2009, 2010, 2011 and so on.
what i want to do is create a copy of the summary page in front of each year
and extract the same data from each year. each year tab uses the exact same
cell. so i want the summary tab to extract the exact same cell data fdor each
different tab.
is there a way to post an example so that everyone understand what i am
trying to do

 

[Ashish Mathur]

Hi,

Your question is not clear. You may mail me your question at
(e-mail address removed)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com