insert from previous worksheets

[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.)

 

[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

 

[melzki]

Thank you very much! I'll let you know after I try it.