Search for a value in a column and copy row to new sheet for all matching values

Greetings All,

I have been working on a macro that allows me to search for a value in a column and copy the row with matching values to a new sheet.
The following web link has greatly assisted me with running a macro - http://www.techonthenet.com/excel/ma...for_string.php

Unfortunately, the raw data i have present doesn't allow the macro to fully function and i need some guidance with resolving this issue.

The current macro only identifies and copies cells with a single value. However my raw data has several options codes within a cell.

Dd.jpg
Is it possible to modify the following formula to identify a specific value within a range of values? If Range("D" & CStr(LSearchRow)).Value = Range("C1") Then

If else should i split the options to separate cells? If that's the case how do i expend the current range from "D" to "D","E","F"?

Truly appreciate your assistance!

Thank you in advance,
Gopi

Hello Dave,

Many thanks for assisting with my query.

I had tried using your code. Unfortunately, it still extracts cells with a single value.

For instance when i try extracting all rows that contain cells with value "RAF" , only the 1st 6 rows are extracted to sheet 2. What i would need is for RAF in row 10,11 and 12 to be copied to sheet 2 as well.

How would this be possible?

Regards,
Gopi

Perfect, thanks a tonne Dave!

Hi Dave,

Please refer to my attachment, the last step i would like to take is instead of extracting rows that contains the search value, i would like to create a macro to extract all rows that does not contain the search value "B1".

Would it be possible to use the same fundamentals of the macro you had provided?

I truly appreciate your assistance

Cheers,
Gopi

Hi.. Maybe change:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

Hi Apo,

Many thanks, it worked perfectly

Dear All,

Jus Amazing..

Many Thanks, it definitely can be solve my problem also

Regards,
Chirag Raval