This is called referencing a cell in another sheet or even workbook. You reference the sheet name and the cell as a formula where you want the balance from the previous sheet to appear. Here are some instructions I had come across some time ago.
How To Display A Value From One Worksheet On To Another Position your cursor on the cell where you want to store a value from another sheet. Press the equals sign. Use Control+page up or Control+Page down to move to the cell whose value you want entered into your original sheet. Press the Enter key. This will grab the information in the cell where you had just moved to, and reference it on your original sheet. Your cursor will be sitting one cell below where you just inserted the info from the other sheet. When the value is changed in the cell where you grabbed the info from is changed, this change will be reflected in this new cell. HTH, Annette -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cathy Sent: Saturday, March 15, 2008 11:58 AM To: Bill Gallik; [email protected] Subject: [JAWS-Users] more questions about excell, After I create my new sheets and give them the name I want, how do I carry my balance over to the next sheet. What I am trying to do is get my balance to go to the next page. Thanks for all the info in advance. I do need step by step instruction on how to do this. My husband can't seem to explain because he wants to use the mouse and I need to use the keyboard to do what he does with the mouse. Again, thanks in advance for all the help to get my checkbook going once again. Cathy and Pilot Dog Deena, and Retired guide, Copper, both golden retrievers, May I never get too busy in my own affairs that I fail to respond to the needs of others with kindness and compassion. - Thomas Jefferson (1743-1826) Visit the JAWS Users List home page at: http://www.jaws-users.com Address for the list archives: http://www.mail-archive.com/[email protected] To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [EMAIL PROTECTED] For help from Mailman with your account Put the word help in the subject or body of a blank message to: [EMAIL PROTECTED] Use the following form in order to contact the management team http://www.jaws-users.com/managers.php If you wish to join the Blind Computing list send a blank email to the following address: [EMAIL PROTECTED] Visit the JAWS Users List home page at: http://www.jaws-users.com Address for the list archives: http://www.mail-archive.com/[email protected] To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [EMAIL PROTECTED] For help from Mailman with your account Put the word help in the subject or body of a blank message to: [EMAIL PROTECTED] Use the following form in order to contact the management team http://www.jaws-users.com/managers.php If you wish to join the Blind Computing list send a blank email to the following address: [EMAIL PROTECTED]
