Linking Worksheets

[agnerc]

Is there a way to link worksheets together, to where I modify one and the other updates?

Thank you,

 

[gallen]

Hello,

Yes, just have both workbooks open, then in one workbook type = and then click on the cell you wish it link to in the 2nd workbook...

 

[agnerc]

Gallen,

I want to make a copy of a worksheet and link both of them together, not just individual cells.