Hi,
I have been stuck trying to find a way to do this, but not able to find anything.
So, I have an excel file with columns and multiple rows. So each column is for represents a particular data and each row is for a different client with a different client name. I have a PowerPoint file template with just 1 slide. In that 1 slide, there is the name of a client, then a few paragraphs about what they do and also data in form of numbers. So this is just for 1 client.
What I want to do is, create multiple 1 page PowerPoint presentations for each client from the excel file I have. The PowerPoint slide will have the same paragraphs and logos, but only the data should change depending on each row of the excel. So, I want to create 1000 ppt slides for each row (representing each client) from that excel file.
Is this possible anyway? have heard that it can be done using VBA, but I don't know how to do it. Any help would be appreciated.
I have been stuck trying to find a way to do this, but not able to find anything.
So, I have an excel file with columns and multiple rows. So each column is for represents a particular data and each row is for a different client with a different client name. I have a PowerPoint file template with just 1 slide. In that 1 slide, there is the name of a client, then a few paragraphs about what they do and also data in form of numbers. So this is just for 1 client.
What I want to do is, create multiple 1 page PowerPoint presentations for each client from the excel file I have. The PowerPoint slide will have the same paragraphs and logos, but only the data should change depending on each row of the excel. So, I want to create 1000 ppt slides for each row (representing each client) from that excel file.
Is this possible anyway? have heard that it can be done using VBA, but I don't know how to do it. Any help would be appreciated.
