HollyJade88
New Member
- Joined
- Jun 23, 2017
- Messages
- 2
Hello, I have a task which needs to be carried out monthly but it's very manual, so I'm looking to automate as much as possible.
I have 26 presentations to complete with multiple charts on each presentation. Copying and pasting each chart to PPT is proving very time consuming.
For each presentation I have an Excel workbook with up to 10 charts on it. I’d like to use a command button in my workbook which when clicked copies each chart and pastes them to the PowerPoint presentation I have open. I’d also like to code in where each chart should be pasted i.e. Chart1 and Chart2 to slide 2 of presentation, Chart3 to slide 3 of the presentation, Chart 4 to slide 5 etc. I'm happy to position and resize each chart once they're pasted into the presentation.
Sadly this level of VBA is well beyond my knowledge, so any help would be greatly appreciated!
I have 26 presentations to complete with multiple charts on each presentation. Copying and pasting each chart to PPT is proving very time consuming.
For each presentation I have an Excel workbook with up to 10 charts on it. I’d like to use a command button in my workbook which when clicked copies each chart and pastes them to the PowerPoint presentation I have open. I’d also like to code in where each chart should be pasted i.e. Chart1 and Chart2 to slide 2 of presentation, Chart3 to slide 3 of the presentation, Chart 4 to slide 5 etc. I'm happy to position and resize each chart once they're pasted into the presentation.
Sadly this level of VBA is well beyond my knowledge, so any help would be greatly appreciated!