Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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.) |
#2
![]() |
|||
|
|||
![]()
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 wrote: 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.) |
#3
![]() |
|||
|
|||
![]()
Thank you very much! I'll let you know after I try it.
"Sarah" wrote: 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 wrote: 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.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What is the quickest method to insert & name multiple worksheets . | Excel Worksheet Functions | |||
What is the quickest method to insert & name multiple worksheets . | Excel Worksheet Functions | |||
Challenging Charting | Charts and Charting in Excel | |||
Protect/unprotect all worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |