Hello ive been cracking my head over this work problem:
There are about 960 excel files, all with different names, of all of these I need to extract 3 columns (they are all standard files so the columns are in the same place).
I need to build a macro so that I copy these 3 columns and paste them into one summary excel file. Sounds simple I know but Ive been having trouble
with the Worksheet_Activate() or with Workbook_Open()
please any code that might help me? Thanks
Bookmarks