Excel page linking

Solved/Closed
Bubba - Mar 13, 2010 at 10:47 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 13, 2010 at 11:11 AM
Hello,
I'm trying to link 5 pages which each have a total amount on, I am looking to put all the totals automatically on one page, what i am asking is how do i link the cells from one page to another on Excel 2007, I have to add I am somewhat of a novice on Excel so any help would be greatly received

2 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 13, 2010 at 11:00 AM
Lets say on sheet1 on cell A10 you have your total and you want to show this value on sheet2 in cell B4

then in B4 write
=sheet1!A10
0
Thankyou for the speedy response, something so easy ! thankyou again
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 13, 2010 at 11:11 AM
You are welcome.
0