Linking Sheets.

[Peter Whyer]

I know how to link separate files but I can't seem to find a way to link
sheets in the same file.
e.g. Sheet B contains a column which I can SUM and I want the result to
appear and update in Sheet A as well as in sheet B
Your help would be appreciated.

--


*
All mail scanned with Norton anti virus
*

 

[Bernard V Liengme]

On Sheet 2 enter =Sheet1!A1 and you should see the value of Sheet1's A1 cell
displayed.
The best way to enter these links when the sheets have more imaginative
names is point and click; type = in Sheet2, open Sheet1 and click on A1; now
click the green check mark in the formula bar.
Bernard

 

[Leo]

Peter:

Enter the following formula into the cell on sheet A

=Sheet2!B6

This should solve your problem.
Have a nice day.
Leo

 

[Peter Whyer]

Many thanks for your help.