Previous Topic Next Topic

Excel page linking

Solved/Closed
Bubba - 13 Mar 2010 à 10:47
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 13 Mar 2010 à 11:11
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

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

Similar discussions

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

6 responses
Convert number to spelling
Sukumar -
mrwagh85 -

28 responses