I am trying to import a list of names into PowerPoint from an Excel spreadsheet, but I want each row on individual slides. I'm unfamiliar with how to begin this process, and hoped that someone who knew how to do this could give me help.

How many rows on your spreadsheet are there? This can be done but depending on how many rows there are will let us know the best way to go about this.

There are 6600+ rows, with three columns categorized (First Name/Last Name, Job, Hometown).

I'm not usually into doing business on the forum but you might want to look at our cheap addin that should do this.

http://www.pptalchemy.co.uk/Simple_merge.html

__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials

I will look into this option, but I'd honestly like someone to help me understand how to do it myself (or at least explain the best place to start).

This is just the bare bones of the code but should get you going!¬
6600 rows will take a while though and that's a big pptx!

Attached Files

to_PPT.xlsm (20.2 KB, 29 views)

__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials

Thank you. I will probably use merge to get me going. would I have to re-write parts of the macros to update the information for each slide?