Linking excel table to powerpoint for easy update
Here's what I'm trying to accomplish:
Lets say weekly you receive an excel spreadsheet with two columns; a seating location and a name. When you receive this spreadsheet, you are tasked with editing a powerpoint slide with a standard classroom look and placing all the people's pictures (from a separate folder) with their names in their newly assigned location.
So far we always go line by line to see where that person was moved and then drop the pictures next them.
I'm sure there is a way to create a table on top of the classroom picture that will pull data from an excel sheet and place them in the appropriate cell (seat number). This way I can just copy the new data, place it into the new powerpoint excel and have it arrange the names accordingly. Furthermore, I'm sure there is also a way to link the pictures to the names and have them show up after the organization.
The issue is, I can't figure out how to do it. Thanks for any help you can give.
|