I am using the 2003 version. I have a spreadsheet that I enter daily account information. This information is automatically totalled at the bottom of the page. I also have a separate spreadsheet that has all my multiple accounts listed.
I am needing help with a formula that take the total from each individual account sheet and copies it to the multiple account sheet automatically when I open the multiple account sheet.
Thank you for your time.
Hi,
1. In the individual account sheet select the cell with the total.
2. Right click and select Copy.
3. Switch to the multiple account sheet and select the cell where you want the total shown.
4. Right click and select Paste Special.
5. When the paste special window open click on Paste Link. Or if your totals are not changing then you can select Paste Values.
Read more on this here:
http://www.exceldigest.com/myblog/20...heet-workbook/
Regards.
Welcome to: http://www.exceldigest.com/myblog/
"Excel help for the rest of us"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks