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.
We are willing to assist, not to carry out your work for free. After 67 posts, we would expect you to attempt a solution of your own. Make use of the macro recorder.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
I have merge script with me, please see attached. This script will consolidate all spread sheets from the selected file location and provide file names. I want to tweak this script by finding path that is available in Sheet1, then, open spread sheet and copy content and paste in to Sheet2 along with the file path. Kindly see if you can help on this.
Reply With Quote
