+ Reply to Thread
Results 1 to 3 of 3

Copy data from Excel to PowerPoint slides/tables

  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/tables

    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/tables

    Instead of copying information into tables, how about copying pictures of excel tables into the slides? The attached shows how to copy Excel objects into a PowerPoint "Template" (not a true template, but a presentation with blank spaces where you want to copy in charts and tables).
    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.

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

    Re: Copy data from Excel to PowerPoint slides/tables

    Thanks for the reply dflak! I'm hoping to copy the data without using Excel Worksheet Object. Does anyone know how to copy just the data into existing tables in PowerPoint using a macro?

+ 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 data from Excel to PowerPoint slides
    By RareNasturtium in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2016, 01:17 PM
  2. Copying multiple tables from Excel into Powerpoint slides
    By OliverBrain in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2015, 11:44 AM
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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

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