+ Reply to Thread
Results 1 to 2 of 2

Transfer Array of range rows into consecutive columns in Powerpoint slide table

  1. #1
    Forum Contributor
    Join Date
    03-07-2006
    Location
    India
    MS-Off Ver
    MSOffice 2016 Professional 64 bit
    Posts
    108

    Transfer Array of range rows into consecutive columns in Powerpoint slide table

    I am trying to copy a fixed number of rows of a 2 column range (say sets of 10 rows each time) and paste these rows into the table (e.g. Table 3) of a duplicated template slide's containing 5 columns x 10 rows (excluding header and top row). I am picking up the ranges into an Array and then trying to paste them. The Array is first sorted in place (By Ref) on 1st column using a 2D QuickSort Array procedure.

    Please Login or Register  to view this content.
    There are many such 2 column disjointed ranges in a sheet in columns 1 & 2 only.

    So the 1st set of 10 rows will be pasted into Columns 1 & 2 of table. The remaining set of <=10 rows of the range will be pasted into the next 4 & 5 columns (column 3 will be just a separator column). So a single slide table will hold only 20 range rows (10 + 10).

    If the range rows exceed 20, e.g. 31, then 20 rows will be pasted into the slide table (as 10 in 1 & 2 columns + 10 rows in 4 & 5 columns) and remaining 11 range rows will be pasted into a similar duplicated slide table as 10 rows in 1 & 2 columns and 1 row in 4 & 5 columns. So each time range rows exceed 20, the template slide containing a blank table will be duplicated to be filled.

    I am currently able to pick up the 2 column range from a sheet.
    I am able to determine how many slides to be created from the number of range rows.

    E.g. 4 Slides:
    Please Login or Register  to view this content.
    • I am not able to determine how to copy paste 20 rows per slide i.e. 10 rows in 1 & 2 columns and <=10 rows in 4 & 5 columns of slide table.
    • I am not able to duplicate slide if range rows exceed 20 rows.
    • I am not able to delete unwanted columns 3,4,5 of table if range rows only fill 1 & 2 columns of a table.

    Is there someone who has done something like this? I am attaching a sample xlsx file and sample powerpoint template to get an idea of what i am trying to do.
    Attached Files Attached Files
    Last edited by junoon; 12-09-2019 at 09:10 AM.

  2. #2
    Forum Contributor
    Join Date
    03-07-2006
    Location
    India
    MS-Off Ver
    MSOffice 2016 Professional 64 bit
    Posts
    108

    Re: Transfer Array of range rows into consecutive columns in Powerpoint slide table

    Does anyone know how to write to a slide table from an array?

+ 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: 07-18-2019, 07:43 AM
  2. Using VBA to copy a Pivot Table to a PowerPoint slide.
    By Keytnknd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2017, 03:22 PM
  3. VBA Transfer Range from Excel to Powerpoint (New or Existing Powerpoint Presentation)
    By ThePeoplesClub in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2014, 02:52 PM
  4. Script to copy excel table in to a powerpoint slide
    By Robert110 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2014, 06:15 PM
  5. add a specific slide to a powerpoint array of slides
    By aviben@bezeqint in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2013, 07:27 AM
  6. macro to copy paste excel name range to powerpoint new slide
    By koi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-17-2013, 04:55 PM
  7. Copy Range from Excel to Powerpoint Slide
    By cricrazy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2009, 07:11 PM

Tags for this Thread

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