Search for multiple string values and copy row to new sheet

**steeley7** · 02-15-2010, 07:18 AM

Hi,
I have some VBA codeof the internet that works fine except it only searches for one string value within the chosen column.

I really need it to search for 3 different strings values and copy the row of data to the new sheet.

Please Login or Register  to view this content.

Can anyone help ???

Thanks
Steeley7

**rwgrietveld** · 02-15-2010, 07:21 AM

Easiest would be to do this:

Please Login or Register  to view this content.

**steeley7** · 02-15-2010, 02:23 PM

thanks will give it a whirl

**projectile** · 10-12-2011, 04:00 AM

Hi

Is there anyway to modify this macro so that the items to be searched (e..g.) can be listed in another sheet in column A, instead of hardcoding the the items

Column A, sheet3
Brew
Second String
Third String

So the macro goes through each of the cells / strings in column a of sheet 3, finds a match in current sheet, and dumps that row into sheet2.

thanks