Paste excel object in PPT

[G2K]

Hi All,

i want a macro to copy a particualr worksheet range say (A2:h20) and paste this to powerpoint presentation slide. i need to update the ppt on daily basis. the sorce and destination will remain same and the object need to pasted on slide no 11.

any help would be apriciated.

thanks in advance

 

[adminfunwn]

You can make tables and graphs inside PowerPoint—but don’t. Don’t even use the Insert, Table, Excel spreadsheet choice. These functions do not work well.
Instead, just open Excel and make your chart or table there. Select the chart or table, copy, and paste into PowerPoint. Voila.
Here’s the magic. If you create a chart in Excel, then paste it into PowerPoint, PPT will automatically adjust the chart style to match the presentation theme. So if you copy this chart in Excel:
Tables do not automatically reformat, but you can easily change them by selecting the table after you paste it into PowerPoint, and then using one of the Quick Styles available from the Table Tools, Design ribbon. For example—the table shown in the slide above looked like this when originally copied in Excel: