Previous Topic Next Topic

Excel page linking

Solved/Closed
Bubba - Mar 13, 2010 at 10:47 AM
rizvisa1 Posts 4478 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
Related:

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
bubba
Mar 13, 2010 at 11:07 AM
Thankyou for the speedy response, something so easy ! thankyou again
0
Answer 2 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 13, 2010 at 11:11 AM
You are welcome.
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses