Macro to search text and copy data from multiple columns.

[venki10]

Hi,

I need macro to search particular Text in workbooks and if found it has to copy corresponding Column 2 and Column 4 data.

Attached example sheet for reference.

 

[Luke M]

What particular text are you looking for? Which columns/sheets should be searched? Where should the col 2 and 4 data be copied to?

 

[AlanSidman]

Crossposted on MrExcel and ExcelForum and appears to be a duplicate of this post

https://chandoo.org/forum/threads/vba-to-search-text-and-copy-data.39773/

 

[venki10]

I want to search NDA text in multiple Workbooks in folder and if found it has to copy corresponding Column 2 and Column 4 data in new excel sheet.