Linking Worksheets

[snash]

How do you link Sheet1 to Sheet 2. When I update Sheet 1, I want it t
update in Sheet 2 automatically as both sheets have similar informatio

 

[Gord Dibben]

To link a cell from source sheet to target sheet enter this in a cell in Sheet2.

=Sheet1!A1 Note this is a draggable formula so you can copy it to other Sheet2
cells.

OR......in Sheet2 in a cell enter an = sign then switch to Sheet1 and click on
A1 and <ENTER>

OR.....select A1 or an entire range in Sheet1 and Copy then go to a cell in
Sheet2 and Paste Special>Paste Link>OK>Esc


Gord Dibben MS Excel MVP

 

[snash]

Hi Gord, thanks for the tips but the paste link option doesn't insert a
new line in Sheet2 if I was to insert one in Sheet1