Hello,
I have a directory with approx 1000 xls-files.
I want in an new excel file to search automatically for string 'Source:' which is always in column A, and copy all test in rows following where 'Source:" is found in each spreadsheet. Thanks in advance for any help?
Regards,
Tom
I have a directory with approx 1000 xls-files.
I want in an new excel file to search automatically for string 'Source:' which is always in column A, and copy all test in rows following where 'Source:" is found in each spreadsheet. Thanks in advance for any help?
Regards,
Tom