Hi all,
I am trying to figure out how to select data in a particular cell in an excel worksheet, open a PowerPoint pack that is already named, and paste the copied data into a particular cell in a table on a slide (i.e. Excel tab 1 cell A1 is pasted into a table on slide 4 row 3 column 2 in PowerPoint). This is to compile a report in PowerPoint from various fields in Excel and therefore would loop for each cell to be copied then move onto another tab, and start the process again but pasting into another table on a different slide on PowerPoint. In effect what we end up with is a PowerPoint slide pack with multiple slides and each one has information pulled from a corresponding tab in excel.
I hope this makes sense, I have also tried to search on this but Im just starting out on the VBA "challenge" so any help would be hugely appreciated!
I am trying to figure out how to select data in a particular cell in an excel worksheet, open a PowerPoint pack that is already named, and paste the copied data into a particular cell in a table on a slide (i.e. Excel tab 1 cell A1 is pasted into a table on slide 4 row 3 column 2 in PowerPoint). This is to compile a report in PowerPoint from various fields in Excel and therefore would loop for each cell to be copied then move onto another tab, and start the process again but pasting into another table on a different slide on PowerPoint. In effect what we end up with is a PowerPoint slide pack with multiple slides and each one has information pulled from a corresponding tab in excel.
I hope this makes sense, I have also tried to search on this but Im just starting out on the VBA "challenge" so any help would be hugely appreciated!
