Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > PowerPoint

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-11-2012, 07:09 AM
atwood121 atwood121 is offline Windows Vista Office 2007
Novice
 
Join Date: May 2012
Posts: 2
atwood121 is on a distinguished road
Default 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.
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Have Powerpoint dynamically update from an excel or other file? oshkosh PowerPoint 3 04-05-2016 06:10 AM
Linking Excel Table to Powerpoint gsteveli PowerPoint 0 05-25-2011 07:50 PM
linking Excel pivot into PowerPoint formatted nhegler PowerPoint 0 11-22-2010 08:05 AM
Easy Update "Table of Contents" feature in Microsoft Word 2007 VS. Word 2010 Xarzu Word 0 09-22-2010 06:54 PM
Excel to powerpoint linking mugezhn Excel 0 07-08-2010 02:56 AM


All times are GMT -7. The time now is 06:16 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft