Running a macro to paste into PowerPoint

[AussieMgr]

Hi Everyone,

I have few tabs in an Excel Sheet with set of data and few graphs. Most of these data and graphs are monthly sales figures formatted on tables to show some trends and percentages.

Each month I need to copy some of these tables and graphs into PowerPoint slides.

I heard there could be away to generate my slides by pressing a button via running a macro - in other word I just update my Excel sheet with latest monthly figures then Excel does the best to generate the PowerPoint slides.

Can someone help here please?

Thank you in advance for all your replies,

AM

 

[Johnny C]

Chandoo has a good article and free code

https://chandoo.org/wp/2011/08/03/create-powerpoint-presentations-using-excel-vba/

 

[AussieMgr]

Thanks Johnny and my apology for the late reply, this is an excellent article ..

Cheers

Sam