Dynamically update data from excel table in PPT slide with chaning dates as worksheets
Hi,
This is Dinesh, having a production report that is daily updated and a new worksheet is added with date to add that day's production data as shown in attached excel sheet. The same production data is pasted on the PPT for senior management review. But we change it manually daily when the new data is added in the new date worksheet. Is it possible to link the latest day's production data and PPT is updated with latest data automatically once the latest data is updated in the new sheet. PPT is also attached here. Please advise with a solution.
Thanking you!
Regards,
Dinesh
|