Forum Discussion
Can I create a MASTER WORKBOOK that updates from different workbooks?
Hi. I am looking for the opposite of this.
Please could you help me.
I have a table of contents (a summary page) - There are different items on there which I need to create separate worksheets for.
The issue is, for each of the sections there is a set sheet I need to use and I want each of the new sheets to copy this. I have a bit of a visual:
| Contents: | Number | ||||
| Section 1 | Outside | 1 | |||
| 1.1 | Garden | 1 | |||
| Section 2 | Inside | 14 | |||
| 2.1 | Door | 4 | |||
| 2.2 | Window | 10 | |||
What i have is Section 1.1 - Garden (this has its own set sheet which has places for images and some standard information regarding works there) there is only 1 of these to create, so i don't need another sheet. But if i did i would need excel to automatically copy this sheet by the number in the last column and create worksheets 'Garden 1, Garden 2, Garden 3....... etc)
Same for Door - I will need this to use 2.1 as the first sheet and then copy it 4 times using Door 1, 2, 3 etc.
and so on...
I would also like all the 'sections' to have the same data in the top few Rows - which will be the customer and location information.
once the sheets are created I can then convert it all into a PDF or Power point presentation.
Please can anyone tell me if this is possible and how to do it.
So far i have tried the developer function, but i am not sure i am doing it correctly and the Macros are blocked, and will not unblock on this computer.
Any help will be really appreciated.