+ Reply to Thread
Results 1 to 2 of 2

Copy data from Excel to PowerPoint slides

  1. #1
    Registered User
    Join Date
    04-13-2015
    Location
    Simcoe, Ontario
    MS-Off Ver
    2010
    Posts
    3

    Copy data from Excel to PowerPoint slides

    Thanks in advance for taking a look at my problem.

    In the Excel file there are several worksheets. The first worksheet named "Industries" is where I drop my raw data from the web. The subsequent worksheets contain the data sorted with various filters. I have a macro to reapply the filters to all the worksheets after new data is entered in “Industries”.

    I would prefer to copy the data...just the values and paste them to PowerPoint presentation. I only want to copy visible data from any of the columns where data is being copied. The number of rows of data will vary each time on all the worksheets.

    On the Job's worksheet there data in column L and N that I want to transfer to a table in PowerPoint slide 2 presentation file. I would prefer to just copy and paste the data to an existing table in PowerPoint file presentation slide 2. I have the data formatted in Excel and I just want to copy to PowerPoint slide 2 into the existing table.

    I want to copy the values from the "Change" worksheet in column L and O to a table in PowerPoint slide 3. Not the headers. The headers already exist in the destination table on slide 3.

    I want to copy the values from "LQ>1.2" Column L to O to a table on slide 5. The number of rows of data will vary each time. Not the headers.

    I want to copy the values from "LQ<0.8" column L to O to a table on slide 6. Not the headers.

    I want to copy the text from Competitive Strength worksheet column L to PowerPoint slide 8. Not the header.

    I want to copy the text from Important to Retain worksheet column L to PowerPoint slide 11. Not the header.

    I want to copy the text from Competitive Weakness worksheet column L to PowerPoint slide 14. Not the header.

    I want to copy the text from Emerging Industries worksheet column L to PowerPoint slide 15. Not the header.

    I want to copy the values from "4 Level NAICS LQ>1.2" columns K through O to tables on slides 19 onward with 15 rows of data on each slide. Not the headers. The destination tables already contain headers.

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

    Re: Copy data from Excel to PowerPoint slides

    This attachment contains instructions on how to copy ranges and tables from Excel to PowerPoint. It is set up to copy them into blank sheets in a PowerPoint "Template" (not a true template, but a presentation with blank pages.)
    Attached Files Attached Files
    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. copy specific excel charts to a specific powerpoint slides
    By coolin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-26-2019, 08:52 PM
  2. macro to copy chart from excel to powerpoint slides
    By subodhgyl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2015, 05:40 PM
  3. Excel data into text boxes in PowerPoint slides
    By cabroncito29 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2014, 03:48 PM
  4. VBA Copy Range from Excel to Powerpoint slides
    By stepet5618 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2014, 04:32 AM
  5. Create and copy screenshots of Excel 2007 sheets into Powerpoint slides
    By *Flipp* in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2014, 06:01 AM
  6. copy cells to powerpoint slides
    By just_some_guy in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-08-2010, 09:34 AM
  7. Excel formulas on different Powerpoint Slides
    By liseladele in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-31-2006, 07:28 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1