Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to create a master Worksheet
I have a excel sheet that I use for all 60 different people. Each prson has
their own workbook and each workbook contains 12 tabs with this excel sheet. If I need to add columns or rows to the sheet it takes forever because I have to go into all 60 workbooks and make the changes individually on all the 12 tabs in each workbook. I am wondering if it is possible to create one master worksheet that I could make additions or deletions to and have it apply the changes to all the other worksheets without me having to go into everyone of them on an individual basis to do so. Does that make sense? Any guidance you could give me would be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to create a master Worksheet
Simply setup all the other workbooks to link directly to your Master workbook.
Step by step: 1. Open master workbook & coworker's workbook. 2. In A1, start typing "=" 3. while still typing formula, select your master workbook, master sheet, and select cell A1 4. Formula should now look something like: =['Book1.xls]Sheet1'!A1 5. Copy this formula over entire sheet (or as large as you feel is necessary) 6. Save & close. Then, copy this linked sheet from the one coworkers workbook to all the rest of the workbooks. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Kim" wrote: I have a excel sheet that I use for all 60 different people. Each prson has their own workbook and each workbook contains 12 tabs with this excel sheet. If I need to add columns or rows to the sheet it takes forever because I have to go into all 60 workbooks and make the changes individually on all the 12 tabs in each workbook. I am wondering if it is possible to create one master worksheet that I could make additions or deletions to and have it apply the changes to all the other worksheets without me having to go into everyone of them on an individual basis to do so. Does that make sense? Any guidance you could give me would be greatly appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to create a master Worksheet
Kim,
If I understand your requirement, all you need to do is to: 1. Select all of the tabs by holding down the Shift key and then selecting each tab. 2. Make you changes This should do it. John "Kim" wrote: I have a excel sheet that I use for all 60 different people. Each prson has their own workbook and each workbook contains 12 tabs with this excel sheet. If I need to add columns or rows to the sheet it takes forever because I have to go into all 60 workbooks and make the changes individually on all the 12 tabs in each workbook. I am wondering if it is possible to create one master worksheet that I could make additions or deletions to and have it apply the changes to all the other worksheets without me having to go into everyone of them on an individual basis to do so. Does that make sense? Any guidance you could give me would be greatly appreciated. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to create a master Worksheet
Kim,
In my last reply, I forgot to mention that you only have to make changes to any one of the spreadsheets that have been selected and the change will be made to the others. John "Kim" wrote: I have a excel sheet that I use for all 60 different people. Each prson has their own workbook and each workbook contains 12 tabs with this excel sheet. If I need to add columns or rows to the sheet it takes forever because I have to go into all 60 workbooks and make the changes individually on all the 12 tabs in each workbook. I am wondering if it is possible to create one master worksheet that I could make additions or deletions to and have it apply the changes to all the other worksheets without me having to go into everyone of them on an individual basis to do so. Does that make sense? Any guidance you could give me would be greatly appreciated. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to create a master Worksheet
I have several different files that all use the same spreadsheet. The data
that is entered into each one is different but the formating is the sames and the required data being entered is the same. I just want to be able to change the formating on one spread and have the changes made on all of the other spreadsheets without me having to do it one sheet at a time. I also don't want the data that has already been entered to change either. Does that make sense. "JCS" wrote: Kim, In my last reply, I forgot to mention that you only have to make changes to any one of the spreadsheets that have been selected and the change will be made to the others. John "Kim" wrote: I have a excel sheet that I use for all 60 different people. Each prson has their own workbook and each workbook contains 12 tabs with this excel sheet. If I need to add columns or rows to the sheet it takes forever because I have to go into all 60 workbooks and make the changes individually on all the 12 tabs in each workbook. I am wondering if it is possible to create one master worksheet that I could make additions or deletions to and have it apply the changes to all the other worksheets without me having to go into everyone of them on an individual basis to do so. Does that make sense? Any guidance you could give me would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a master workbook? | Excel Discussion (Misc queries) | |||
compare s/s and create master s/s | Excel Discussion (Misc queries) | |||
How?Create master worksheet xls that will update previous records | Excel Discussion (Misc queries) | |||
create a master worksheet template | Excel Discussion (Misc queries) | |||
Create a master worksheet based on 2 different worksheets | Excel Worksheet Functions |