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.
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:
- 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.
Bookmarks