Final Friday Fix: October 2019 Challenge
25 October 2019
On the final Friday of each month, we’re going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel / Power BI fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you’re playing for bragging rights only!
This month’s Final Friday Fix involves the automation of paste individual charts from the Excel worksheet to the Power Point slides. In our challenge for this month, we have two separate charts as shown below in the worksheet and we want to automatically paste both charts to separate presentations of PowerPoint.
and the result would be:
We want to automate this process without manually adding each chart individually. Sounds like a job for VBA this month…
Sounds easy? Then why not have a go? We’ll publish one solution in Monday’s blog. Have a great weekend in the meantime!