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

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

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

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" wrote:

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

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

Mike H;253207 Wrote:
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" wrote:

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

If you're not sure of your syntax select the cell were the formula
should be
Enter =sum(
Click the cell you want to sum
While pressing the shift key select the last tab you need.
Add the closing parenthesis
Done


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=70701

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

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?

"Pecoflyer" wrote:


Mike H;253207 Wrote:
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" wrote:

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

If you're not sure of your syntax select the cell were the formula
should be
Enter =sum(
Click the cell you want to sum
While pressing the shift key select the last tab you need.
Add the closing parenthesis
Done


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=70701

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

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" wrote in message
...
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?

"Pecoflyer" wrote:


Mike H;253207 Wrote:
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" wrote:

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

If you're not sure of your syntax select the cell were the formula
should be
Enter =sum(
Click the cell you want to sum
While pressing the shift key select the last tab you need.
Add the closing parenthesis
Done


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile:
http://www.thecodecage.com/forumz/member.php?userid=14
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=70701

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

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" wrote:

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" wrote in message
...
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?

"Pecoflyer" wrote:


Mike H;253207 Wrote:
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" wrote:

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

If you're not sure of your syntax select the cell were the formula
should be
Enter =sum(
Click the cell you want to sum
While pressing the shift key select the last tab you need.
Add the closing parenthesis
Done


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile:
http://www.thecodecage.com/forumz/member.php?userid=14
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=70701

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

Hi,

Your question is not clear. You may mail me your question at


--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Vic" wrote in message
...
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" wrote:

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" wrote in message
...
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?

"Pecoflyer" wrote:


Mike H;253207 Wrote:
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" wrote:

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

If you're not sure of your syntax select the cell were the formula
should be
Enter =sum(
Click the cell you want to sum
While pressing the shift key select the last tab you need.
Add the closing parenthesis
Done


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile:
http://www.thecodecage.com/forumz/member.php?userid=14
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=70701