am trying to load multiple workbook into the same sheet, these workbooks will all contain one common column header. After i load multiple workbook, i would like to search for the rows i wanted and paste it onto a new sheet.

so far i have done the search and paste part but the part that requires to load multiple workbook is quite tough, can anyone help me out on this? thanks.

Please Login or Register  to view this content.