Hi everyone,
Hope this finds you well!
Hoping I would get help for this question - The excel file attached is the back-end chart of one of my PowerPoint slides.
Information about the attached:
1. Columns A to H contains the data
2. Cell "K1" is a drop-down which contains the data of "Column A" as options
I was able to figure out the following:
1. Open the PowerPoint presentation
2. Open the back-end of the chart
3. Navigate to cell "K1" of the back-end
Solution I'm looking for: It would be of great help if some one could help me with a VBA code which could:
1. Change the value in cell "K1" to the very next value present in drop-down i.e. next row of "Column A"
2. Save the chart in a new PowerPoint deck
3. Repeat the same for 48 times to cover all the values present in "Column A"
Thanks a lot in advance!
Bookmarks