| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting data from sheets into seperate workbooks based on formul | Excel Worksheet Functions | |||
| Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
| Combining Worksheets / Seperate Workbooks | Excel Discussion (Misc queries) | |||
| How to seperate a text group in once cell into many cells | Excel Discussion (Misc queries) | |||
| Formula Links to seperate workbooks | Excel Discussion (Misc queries) | |||
Linear Mode
