Dear Excel experts,
I would like to ask for your kind help with extending an existing VBA code to achieve additional function.
Please see the attached example sheet. It includes a VBA code which automatically exports all charts from the worksheet to a Power Point presentation document when the "Generate Report" button is pushed. I would like to extend this code to also copy-paste the tables which are below the charts. I would like to have every table to be copied to a separate slide, starting with tables called "Report Internal", then followed by tables called "Report External". The tables can be coped as pictures.
Could you please help?
Thank you
Bookmarks