Automated Reporting - From Excel to PPT

[Legend_X]

Hi Fox

Case:
I have a summary tab that has the same tables in all the models I have built and unified with the same tables as PPT, it requires me to fill in the result after any updates in the model inputs(which is daily). This is quite challenging if I work on 5 urgent projects solo.

I have been trying to make life easier by automating copying the result from Excel to the business presentation or issuing a new PPT by clicking on some button with a macro.

Questions:
1- Is it possible with VPA? What Modules and Functions will help?
2- What the structure of the code should be?
3- Any tips or tricks (what are the best practices in building such an idea)?

If we cannot do this with VPA, what is the easier and more efficient way to build such an idea?

I would be happy to hear your opinions.

Thanks in advance.

 

[Rijnsent]

Hi Legend_X, welcome to the forum.
What you're looking for is something many people are struggling with. Yes, you can do this with VBA, but I guess from your post that you're a VBA-beginner? Than that code is quite a steep mountain to climb. As a starting point, you could check out this site: VBA Paste from Excel to PowerPoint - Copy Paste Excel to PowerPoint or this one: VBA Macro to Transfer Data from Excel to PowerPoint - Vegaslide

However, if you don't want to learn VBA, you can also buy an add-in that makes linking PowerPoint to Excel much easier & faster, see e.g. : LP: Link Excel to PowerPoint