Hello community,

For some monthly reporting I have to make screenshots from different sheets of an Excel workbook and past them to different Powerpoint slides in one file.

More information and slides are also coming from other departments, so the number and order of slides the screenshots are pasted to is different from month to month.

A macro that does the following steps could solve my problem:
- Collecting and showing (in the excel source file) the slide title and/or slide number of a powerpoint file which is to be defined
- Display all Excel sheets which could be copied as a screenshot
- Summarizing the gained information on a separate sheet in the source file or in a user form, so that…
- The user can indicate there which sheet should be copied as screenshot to which powerpoint slide in the defined powerpoint file

Does somebody has a good idea?

Thanks and regards
Philipp