Linking Worksheets

S

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
 
G

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
 
S

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
 
Top