![]() |
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? |
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