+ Reply to Thread
Results 1 to 2 of 2

Copying data from excel to Powerpoint

  1. #1
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    493

    Copying data from excel to Powerpoint

    Hello,

    I have a macro which copies data in a specific cell in my worksheet to a bookmark in a specific word document.

    Is there a way to do this in PowerPoint? I have noticed that PPT does not have bookmarks?

    TIA

    Chris

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,067

    Re: Copying data from excel to Powerpoint

    There are a couple of ways to do this: one way is to make a link in PowerPoint to the Excel Document. When you open PowerPoint and update links, it will open the Excel document, extract the data and display it. This is fine if the Excel document opens and closes quickly an you don't have too many links. Some of the advantages of this method is that the PowerPoint presentation itself is flexible and you get real time data without having to open the Excel sheet manually. The downside is that if you have a lot of links and the sheets are slow, it can take time.

    An alternative is presented here: https://www.excelforum.com/tips-and-...rom-excel.html. In this version you copy static pictures of ranges and charts - the advantage of this method is that it is quick. The disadvantage is that it only works with a fixed format presentation.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 08-23-2016, 09:43 AM
  2. Copying data from Excel to PowerPoint as text or table
    By BillDoor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2016, 04:12 AM
  3. Excel/PowerPoint VBA teaser: How to change data labels in PowerPoint chart by VBA?
    By lukelucky in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2015, 11:47 AM
  4. Data input in powerpoint to select data in excel and report back to powerpoint
    By daveybright in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2009, 09:54 PM
  5. Copying Data From Excel to a Powerpoint Presentation
    By Vishal Dsouza in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-27-2007, 10:54 AM
  6. Copying Data From Excel to a Powerpoint Presentation
    By Vishal Dsouza in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-27-2007, 08:48 AM
  7. copying data from Powerpoint to Excel
    By DB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2005, 12:05 PM

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