PDA

View Full Version : Copying data from Excel, Pasting into existing Powerpoint table



MagicCripple
11-21-2019, 03:11 PM
Hi,

A bit of info...
This is for a trivia game I am helping someone with. The Categories, Questions, etc. are written in Excel, and I am looking to populate an existing Powerpoint with new data as needed. Everything is already sized/formatted the way I like in the Powerpoint, so I'm just trying to figure out how to:

copy cells from Excel Spreadsheet
select Powerpoint slide number
select existing table number
and paste into the appropriate Powerpoint column, and row, if possible keeping the powerpoint table size/formatting.

I am pretty new to vba/macros, so I hope this is fairly straightforward/do-able.

Attached are Screenshots of my Powerpoint and Excel Documents. Any more info need I would be happy to provide.