import data from previous sheet in excel

[gasman]

I have created an excel spread sheet, to track data over multiple years. As
I create a new sheet for a new year, hou do I Import final tallys from the
previous year i n a formula, so I don't have to manually update the
'sheet'! command

 

[David Biddulph]

Click in the destination cell, type the = sign to start the formula, then go
to the source sheet and click in the source cell, which will put that
cells's reference into your formula. Hit enter.