I have a monthly report spreadsheet with about 20 different cell ranges that each need to be pasted into pre existing powerpoint slides as an image and resized to a unique size per range pasted in.
There is also a pre-existing image on each slide (from the prior month) that needs to be removed. (This part isn't too much of an issue as they are quick to delete. The copy, pasting and manual resizing of each range is the trouble.)
I've had a play with a couple of macro's online but have only found ones to pay a single range without a choice in dimensions. Is there anything else I can try?
Let each range be Data1 Data2 Data3 etc.