VBA Search string in Column B and then copy row to a specified row in another sheet

[bone343]

Hi,

I have the following situation:

I need to make a string search in column B", but only starting in row 2.
Everytime the string "x" is found in that column, I need to copy the row where ''x'' was found to another sheet, starting on row 2.
I can define a row limit for the search, for example from "B10:B100".

Can anyone help me with the code?


Thank you!

[Leith Ross]

Hello bone343,

Try this macro. Add a new VBA module to your workbook and paste the code into it. You can then call the macro using the keys ALT+F8 or attach it to button.

Please Login or Register  to view this content.