A quick question

  • Thread starter Thread starter Rob Ireland
  • Start date Start date
R

Rob Ireland

I've got a quick question on behalf of the boss here

He's got a worksheet with several pages on it for his supplier info.

What he wants to to is to link cells on one page (tab) to that of another.

I dold him that he COULD just copy and paste the contents of one
worksheet to the bottof of the other, but that can get pretty sloppy.

Is this doable in excell? If so, how is it achieved? (detailed syntax
would be very helpful, if possible.


Thanx in advance!
 
Hi Rob,

=othersheet!A5
='other sheet'!A5

you can also do this by placking the = sign then
select the other sheet and the cell and return to the original sheet.
 
Note sure if this is what you mean but give it a try.

For instance if you want a cell in sheet 1 (say a1) to be
displayed on sheet 2 (say in cell b15) then in cell b15
on sheet 2 the formula should be =sheet1!a1

The contents of this cell will update every time the
value in the sheet 1 changes
 
Back
Top