Can I link multiple sheets within a workbook together .....

T

Tjepsen

Currently I have one sheet per month and would like to add another sheet as a
"year end" tally sheet. Is there a way to link multiple sheets within a
workbook and have them automatically sum together???
 
G

Guest

hi,
yes and there are a number of techniques to use to do it.
I am not sure about your data but i would just use a
simple formula like =(sheet1!sometotalcell). this would
bring the data over to the summery sheet. set in up in
monthly columns or by catagory with months down the side.
then summ the totals for grand year end total.
 
Top