Linking Sheets.

  • Thread starter Thread starter Peter Whyer
  • Start date Start date
P

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
*
 
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
 
Peter:

Enter the following formula into the cell on sheet A

=Sheet2!B6

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