insert from previous worksheets

M

melzki

Not sure how to say this question, but is it possible to create a series of
worksheets wherein several cells on one sheet would carry over to
corresponding cells on the next sheet? (The purpose is to keep a running tab
of hours on my payroll spreadsheets.)
 
S

Sarah

If I'm understanding correctly, you should be able to use the formula

=sheetname!cell

example: in destination cell, I want last month's end balance to flow
to this months beginning balance. The end balance is on January tab,
cell A16. I would type =January!A16

You can also just type '=' (without the quotes) and click on the cell
you want it to reference.

Hope this helps. If not, post back with more detail please.

Sarah
 
Top