Copy excel to power point, one slide per row

Baloo1985

New Member
Joined
Nov 15, 2016
Messages
1
Hi everyone,

I am new to this forum, so sorry if i am posting this in the wrong place.

I am looking for some help to write a VBA to copy some data in excel to power point slides.

[TABLE="class: grid, width: 860"]
<colgroup><col span="10"></colgroup><tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[TD]Column E[/TD]
[TD]Column F[/TD]
[TD]Column G[/TD]
[TD]Column H[/TD]
[TD]Column I[/TD]
[TD]Column J[/TD]
[/TR]
[TR]
[TD]Value a1[/TD]
[TD]Value a2[/TD]
[TD]Value a3[/TD]
[TD]Value a4[/TD]
[TD]Value a5[/TD]
[TD]Value a6[/TD]
[TD]Value a7[/TD]
[TD]Value a8[/TD]
[TD]Value a9[/TD]
[TD]Value a10[/TD]
[/TR]
[TR]
[TD]Value b1[/TD]
[TD]Value b2[/TD]
[TD]Value b3[/TD]
[TD]Value b4[/TD]
[TD]Value b5[/TD]
[TD]Value b6[/TD]
[TD]Value b7[/TD]
[TD]Value b8[/TD]
[TD]Value b9[/TD]
[TD]Value b10[/TD]
[/TR]
</tbody>[/TABLE]


now I have the same table minus columns A&B in PowerPoint slides and I need each row to be a separate slide by itself. And I need this to be pasted as data not as picture.
Also is it possible to have the values in Columns A&B as simple text for the slide title? Something like "Value a1 - Value a2"

I really appreciate your help with this.

Thanks
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top