how to link an entire worksheet to another

[baileygrrrl]

I have two identical worksheets on my company network - both in different
locations. What I want to do is link workbook a to workbook b in it's
entirety without having to do it cell by cell. How can I do this?

Thanks,

 

[Gord Dibben]

You wouldn't want to link an "entire" worksheet to another.

That's a lotta cells.......16777216

What you can do is have both books open.

Select the range you want to link from first sheet and copy that range.

Select other book and on a new sheet Paste Special>Paste Link>OK>Esc.

OR simply save the first workbook to two different locations each time you
save it.


Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
'Saves the current file to a backup folder and the default folder
'Note that any backup is overwritten
Application.DisplayAlerts = False
ActiveWorkbook.SaveCopyAs Filename:="E:\GordStuff\Backup\" & _
ActiveWorkbook.Name
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub


Gord Dibben Excel MVP