Evening All,
Thanks in advance for any help you can offer.
So...
I have control of a number of projects and each month a 2 page PowerPoint slide needs to be completed for each with snippets of information regarding it's progress, funding, safety etc... the layout remains the same for all projects as does basic information such a project code etc. I currently have 32 projects so 32 PowerPoint files. These files get sent out to the relevant engineers for update and eventually get returned. I then Combine the file to make one PDF report and issue. Unfortunately, many of the engineers have little understanding of PowerPoint resulting in many hours spent re-aligning/formatting each slide.
My solution was to have an excel workbook where each tab represented a project. Cells would then be linked to the corresponding Powerpoint file and update the slide automatically. I now have one powerpoint file with 64 slides (2perproj) and each linked to the main excel book...All Good!! However, each cell has to be copied from excel and Pasted(Linked) on to the PowerPoint slide which is painful. .
Further more, new projects arrive daily which means a new tab in excel and new powerpoint slide. Obviously I can copy the layouts etc, but all of the links need to be updated.
The question..
I wanted the first tab to have a list of projects and when a new project is added, excel automatically inserts a new tab, copies the layout and inserts a new Powerpoint Slide, then update the links accordingly...
Can it be done?
Thanks in advance for any help you can offer.
So...
I have control of a number of projects and each month a 2 page PowerPoint slide needs to be completed for each with snippets of information regarding it's progress, funding, safety etc... the layout remains the same for all projects as does basic information such a project code etc. I currently have 32 projects so 32 PowerPoint files. These files get sent out to the relevant engineers for update and eventually get returned. I then Combine the file to make one PDF report and issue. Unfortunately, many of the engineers have little understanding of PowerPoint resulting in many hours spent re-aligning/formatting each slide.
My solution was to have an excel workbook where each tab represented a project. Cells would then be linked to the corresponding Powerpoint file and update the slide automatically. I now have one powerpoint file with 64 slides (2perproj) and each linked to the main excel book...All Good!! However, each cell has to be copied from excel and Pasted(Linked) on to the PowerPoint slide which is painful. .
Further more, new projects arrive daily which means a new tab in excel and new powerpoint slide. Obviously I can copy the layouts etc, but all of the links need to be updated.
The question..
I wanted the first tab to have a list of projects and when a new project is added, excel automatically inserts a new tab, copies the layout and inserts a new Powerpoint Slide, then update the links accordingly...
Can it be done?
