Shanmugam
05-24-2016, 05:19 PM
Hi,
I am looking for a macro to consolidate spreadsheet data based on the specific path that has mentioned in the worksheet.
For an example, in a worksheet, I will have file path mentioned. Macro should get in to the mentioned path, open the spreadsheet, copy data from worksheet (all spreadsheets will have 1 worksheet only) and paste into next worksheet of current spreadsheet along with path name. If the file is not valid or not opening, then that file should be skipped and keep moving to the next path mentioned in the spreadsheet. All files will be xls or xlsx.
I have attached the example screen shot of this request would like, kindly review and advise suitable macro. Thank you for the help in advance.
I am looking for a macro to consolidate spreadsheet data based on the specific path that has mentioned in the worksheet.
For an example, in a worksheet, I will have file path mentioned. Macro should get in to the mentioned path, open the spreadsheet, copy data from worksheet (all spreadsheets will have 1 worksheet only) and paste into next worksheet of current spreadsheet along with path name. If the file is not valid or not opening, then that file should be skipped and keep moving to the next path mentioned in the spreadsheet. All files will be xls or xlsx.
I have attached the example screen shot of this request would like, kindly review and advise suitable macro. Thank you for the help in advance.