Can I group or link sheets in seperate workbooks?

  • Thread starter Thread starter skyler
  • Start date Start date
S

skyler

I am using Excel 2002.
I have a master workbook that I routinely make changes to. I need to
display the indiviual sheets within the master workbook across a network.
How can I link the individual sheets in the master to a sheet in a different
workbook that will reflect any change I make. This should include row/column
deletions/insertions and all formating. I'm looking for an exact duplicate
of the master sheet.
Is this even possible?
 
There is a legacy feature that allows multiple workbook editing which might
help, you can access it by typing in the immediate window of the VBE
(Alt+F11):

Application.Dialogs(xlDialogWorkgroup).Show
 
Back
Top