Ok, thus far I have figured out how to display the value from one cell in one worksheet to a cell in another worksheet. I would think that there is a way to select a series of cell in one worksheet and have their sum, average, etc. displayed on a cell on another sheet, but I am yet to figure that out. So for the time being, you could have the sums calculated on the first worksheet, and then have the value of the cell where the sum is calculated displayed on the second sheet. The directions for doing this are pasted below.
HTH Annette 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 now 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, the change will be reflected in this new cell. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Annette Carr Sent: Thursday, August 10, 2006 8:34 AM To: [email protected] Subject: RE: *****SPAM***** [jaws-users] excel question You've got a good plan going. I now know not to send attachments. Thanks for all your work on this list. Annette -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of David Ferrin Sent: Thursday, August 10, 2006 6:52 AM To: [email protected] Subject: *****SPAM***** [jaws-users] excel question Attachments are not permitted on this list and as such I have Yahoo set to remove them from any and all messages in an attempt to prevent viruses from being transmitted through this forum. I feel it has prevented more problems than it has caused. David Ferrin [EMAIL PROTECTED] [Non-text portions of this message have been removed] Visit the JAWS Users list home page at: http://www.jaws-users.com For a complete list of email commands pertaining to the JAWS Users List send a blank email to: [EMAIL PROTECTED] Visit the new archives page at the following address http://www.mail-archive.com/[email protected]/ Yahoo! Groups Links Visit the JAWS Users list home page at: http://www.jaws-users.com For a complete list of email commands pertaining to the JAWS Users List send a blank email to: [EMAIL PROTECTED] Visit the new archives page at the following address http://www.mail-archive.com/[email protected]/ Yahoo! Groups Links Visit the JAWS Users list home page at: http://www.jaws-users.com For a complete list of email commands pertaining to the JAWS Users List send a blank email to: [EMAIL PROTECTED] Visit the new archives page at the following address http://www.mail-archive.com/[email protected]/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/jaws-users/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
