Hi,
I need your help specifically a macro to consolidate data from a particular worksheet on different excel files into a workbook with the same sheet name. See attached file.
Source sheetname in different excel files = AllItems
Consolidated sheetname in new workbook = AllItems
I want to copy only those data with "R" in column E (copy data from column A to S)
Thank you very much for your help.
Regards,
Jeff
Bookmarks