Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
melzki
 
Posts: n/a
Default insert from previous worksheets

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   Report Post  
Sarah
 
Posts: n/a
Default

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   Report Post  
melzki
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the quickest method to insert & name multiple worksheets . clyonesse Excel Worksheet Functions 8 September 20th 05 10:55 PM
What is the quickest method to insert & name multiple worksheets . clyonesse Excel Worksheet Functions 0 January 20th 05 06:15 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 06:57 PM
Protect/unprotect all worksheets Janna Excel Worksheet Functions 2 January 7th 05 01:01 AM
HELP! How do you--> Lock a set of rows but also link worksheets to FRUSTRATED Excel Discussion (Misc queries) 6 December 29th 04 10:05 PM


All times are GMT +1. The time now is 11:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"