Hi,
I currently have a spreadsheet with 14 chart sheets located within it. I am wanting to write a VBA code that when a command button is pressed each sheet is copied to a MS PowerPoint Presentation template.
When i have tried the insert method the chart changes depending on which chartsheet is opened.
Is this sort of VBA programming able to occur?
Or is there a way to set up a PowerPoint Presentation that will auto update it's charts to be the same as the excel's workbook chartsheets?
I hope I made sense.
Any help is greatly appreciated.
Bookmarks