Hello,
I have a column of data. I want to write a macro that, depending on how I set it, will go down through that column, and select/observe every 2nd, 3rd, 4th, etc. row and paste/populate each of those rows onto its own PowerPoint slide.
The trouble I'm running into is going through these two ranges simultaneously so that, for example:
In the case I've set it to every 2nd row:
Excel 1st row -> PPT 1st slide
Excel 3rd row -> PPT 2nd slide
Excel 5th row -> PPT 3rd slide
Excel 7th row -> PPT 4th slide, etc.
In the case I've set it to every 3rd row:
Excel 1st row -> PPT 1st slide
Excel 4th row -> PPT 2nd slide
Excel 7th row -> PPT 3rd slide
Excel 10th row -> PPT 4th slide, etc.
Etc.
Thanks in advance for any help,
ML
I have a column of data. I want to write a macro that, depending on how I set it, will go down through that column, and select/observe every 2nd, 3rd, 4th, etc. row and paste/populate each of those rows onto its own PowerPoint slide.
The trouble I'm running into is going through these two ranges simultaneously so that, for example:
In the case I've set it to every 2nd row:
Excel 1st row -> PPT 1st slide
Excel 3rd row -> PPT 2nd slide
Excel 5th row -> PPT 3rd slide
Excel 7th row -> PPT 4th slide, etc.
In the case I've set it to every 3rd row:
Excel 1st row -> PPT 1st slide
Excel 4th row -> PPT 2nd slide
Excel 7th row -> PPT 3rd slide
Excel 10th row -> PPT 4th slide, etc.
Etc.
Thanks in advance for any help,
ML