Find and extract specific text from within directory of Excel files

TMM1968

Board Regular
Joined
Jul 16, 2012
Messages
59
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
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,108,816
Messages
5,525,058
Members
409,617
Latest member
Lenaf

This Week's Hot Topics

Top