+ Reply to Thread
Results 1 to 5 of 5

Multiple text boxes (125) over 25 slides each linked to excel cell

  1. #1
    Registered User
    Join Date
    01-18-2009
    Location
    Leeds, England
    MS-Off Ver
    Excel 2007
    Posts
    10

    Multiple text boxes (125) over 25 slides each linked to excel cell

    Hi all,
    I am reasonably excel proficient BUT am totally stumped at how to do this short of learning VB!

    I teach kids 25 lessons a week and each lesson has up to 5 learning points that i want to display on my projector screen.

    I really want to have a 25 slide powerpoint in which each slide has the learning points from my excel planning sheet where i type in content of lesson, equipment needed and LEARNING POINTS.

    Any ideas? - i've considered learning C++ or C# as i'm that desperate

    Please give a stressed teacher a hand!

    Cheers

    James

  2. #2
    Registered User
    Join Date
    10-06-2003
    Location
    Ashford, Kent - Working in London
    MS-Off Ver
    Office 365
    Posts
    95
    James,

    I'd like to help, but not sure I understand your exact requirements.

    Can you explain a little further?

    Chris.
    Big Chris

  3. #3
    Registered User
    Join Date
    01-18-2009
    Location
    Leeds, England
    MS-Off Ver
    Excel 2007
    Posts
    10

    Red face more info

    hi chris, thanks for replying

    so, I've got a file that has (amongst other items) a sheet with

    Classname Learning Item 1 Learning Item 2 ... Learning Item 5
    Lesson 1
    Lesson 2
    ...
    Lesson 25

    Each Learning Item will have a text string like "determine the specific heat capacity of a brass block"

    My perfect powerpoint will have a separate slide for each of the 25 lessons on which will be displayed 5 text boxes containing data from each of the 5 learning items from that Lesson's row!

    Any ideas

    thanks for thinking!

    James

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372
    Hi,

    do your learning points change much? If you only set them up once and then just do some adjustments every now and then, I'd go for copy and paste.

    If you want to automate creating a Powerpoint presentation from Excel content, you're sure looking at some VERY heavy VBA.

    You could create an outline in Word and import that into PPT, but importing from Excel is not that trivial, unless you want to show a table as an embedded object.

    cheers

  5. #5
    Registered User
    Join Date
    01-18-2009
    Location
    Leeds, England
    MS-Off Ver
    Excel 2007
    Posts
    10

    thanks

    hi, thanks for replying

    yes the learning items change weekly hence the auto update. I thought it looked like VBA would be needed!

    I know that word lets you paste special - link (rtf) a cell entry but powerpoint only allows you to link an unformattable entry from excel

    thanks for the help anyway!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1