ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I group or link sheets in seperate workbooks? (https://www.excelbanter.com/excel-discussion-misc-queries/203095-can-i-group-link-sheets-seperate-workbooks.html)

Skyler

Can I group or link sheets in seperate workbooks?
 
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?

Lori

Can I group or link sheets in seperate workbooks?
 
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

"skyler" wrote:

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?



All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com