Hi,
I need help to combine worksheet named "Metal List" from different Workbooks who have many worksheets and the worksheet name "Metal List",into one sheet to get a consolidated data and I want it in a new workbook. I want the 1st row of all the merging sheets to be ignored as they contain the headings.
I am using the below code but its not being very useful as it seems to copy the data of the first sheet twice!! and does not ignore the first row so there are multiple heading in the sheet.
{If possible can it also automatically combine the worksheet "metal List" of workbooks saved in that particular folder or drive?}
Many Thanks for your help
Bookmarks