| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Editing Data in Multiple Worksheets/Workbooks
In Excel 2003, I have several workbooks (all with multiple sheets) all linked
to one 'master' workbook. All worksheets have the same basic row setup. Is there a way to make row additions/deletions 'carry over' from my master workbook into the other workbooks? I know you can use CTRL to modify several sheets in the same workbook at once, but is there a way to do this among workbooks? Any help would be appreciated! Thanks! -Alison |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Editing Data in Multiple Worksheets/Workbooks
There is a legacy feature that allows you to edit sheets from more than one
workbook simultaneously. To access it enter in the immediate window (Alt+F11): Application.Dialogs(xlDialogWorkgroup).Show "Alison Ernst" wrote: In Excel 2003, I have several workbooks (all with multiple sheets) all linked to one 'master' workbook. All worksheets have the same basic row setup. Is there a way to make row additions/deletions 'carry over' from my master workbook into the other workbooks? I know you can use CTRL to modify several sheets in the same workbook at once, but is there a way to do this among workbooks? Any help would be appreciated! Thanks! -Alison |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
| Editing data on multiple worksheets | Excel Discussion (Misc queries) | |||
| editing and analysis of cells in multiple worksheets AND workbooks | Excel Discussion (Misc queries) | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Linear Mode
