I have 47 Excel files which contain charts. In each file there are at least 10 chart sheets per file, so over 470 individual chart sheets.
The data for the charts is in a separate file, and the data has been entered in rows. The data range starts from Column C and ends in Column CF.
When the graphs were originally created by my predecessor, the data range was defined from columns C to BZ.
Rather than manually update each chart sheets, is there a macro which can update the files (including all the separate chart sheets within the file) from BZ to CF.
Please help.
Thanks.
The data for the charts is in a separate file, and the data has been entered in rows. The data range starts from Column C and ends in Column CF.
When the graphs were originally created by my predecessor, the data range was defined from columns C to BZ.
Rather than manually update each chart sheets, is there a macro which can update the files (including all the separate chart sheets within the file) from BZ to CF.
Please help.
Thanks.