I need to copy a table(range of cells) from an excel sheet to an Excel Chart Object's Sheet embedded in a PowerPoint Slide
Scenario:
Excel File (Test.xls): Contains a table
Power Point File (Test.ppt): Contains an embedded Excel Chart Object, when I double click on this it shows me two excel worksheets - Chart(this sheet contains a chart), and the other sheet, Sheet1 (contains table which is identical to the table in Test.xls)
How do i copy data from the table in Test.xls to the table in Sheet1 in the object in Test.ppt?
Thanks in Advance!!!