Hi guys n girls
I create a number of charts in xls workbooks that are used in PowerPoint reports on a weekly basis. One workbook per PPT report. The charts are always the same (data is updated, and a narrative is updated), these then replace/update the corresponding chart in PPT, placement/order does not change. Currently I use copy and Paste but would like to automate the process via a macro. Does anyone know of an existing macro that would point me in the right direction?
Please note that I'm a novice with macros but keen to learn