Can I group or link sheets in seperate workbooks?

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?
 
L

Lori

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Multiple workbook sheets into one workbook 0
Editing Data in Multiple Worksheets/Workbooks 1
Link one worksheet in a workbook to another worksheet in same work 1
Copying Sheets between workbooks without links 3
Referencing Worksheets in separate Workbooks 5
How can I link two workbooks together 2
create multiple sheets using info from one 2
I want to link sheets in excel to a master sheet in excel 1

Top