My excel last month data contains range of data in 8 sheets and graphs included based on the data in the excel. in current month once i create the new data, i want to update only the range of data in the last month excel so that the graphs will not need to be recreated every month.
please see the attachment for the existing data excel sheet
You can download and run the following macro: http://www.sascommunity.org/wiki/Excelling_to_Another_Level_with_SAS
It can be used to either modify the data in the existing worksheets and/or use the existing workbook as a template and import the desired range of data.
Art, CEO, AnalystFinder.com