Hi
I have attached a excel file showing a list (3 column, 12 rows).Book_Ex.xlsx
This is short version of my "real" excel sheet that has over 3500 rows.
I would like to make a macro which could scan the sheet for keywords. Let's say just 3 words for the sake of the example: "Structural", "fatigue" and "ULS". Only column 3 need to be scanned for keywords.
I would like the macro to select the entire row containing the keyword(s) and copy them to a new excel sheet (sheet2) while the other rows (not containing the keywords) shall be copied to another sheet (sheet3).
I am not very good a programming so I would very much appropriate some help.
Thanks.
Regards.
Bookmarks