Hello everyone,
I have been searching for hours but have not really found what I need. Is there a way to merge 6 workbooks, each with 1 worksheet and different columns needed from each into a Master workbook with the filename in column A and the specific columns of data from each? I hope this makes sense, but any help would be greatly appreciated.
I have been searching for hours but have not really found what I need. Is there a way to merge 6 workbooks, each with 1 worksheet and different columns needed from each into a Master workbook with the filename in column A and the specific columns of data from each? I hope this makes sense, but any help would be greatly appreciated.
