VBA: search multiple keywords in multiple columns, then move rows to second sheet

[mglidden]

Hello,
I am very new to VBA and my head is spinning trying to figure out what to do. Any help on my question is very much appreciated!

I have a sheet of customer info and am just looking to run a macro that searches for specific keywords in a couple of columns (an OR situation), and if any are found I would like the entire row in which the keywords are found to be cut, moved to a second sheet, then delete the blank row in the first sheet. Unfortunately, the sheet contains sensitive data so I can't really post the sheet as an example. I have found a few pieces that would work but I can't get them to all work together.

Example:
Search for several specified "Company Name" in both Columns E and G. If found, cut the row in which it is found and move it to Sheet2. Delete the blank row from Sheet1.
The sheets have thousands of lines so I need to search the entire sheet.

Again, any assistance is greatly appreciated as I am just spinning my wheels at this point. Please let me know what questions you have about what my vision is or how the data is set up.

Thank you!

 

[Peter_SSs]

Welcome to the MrExcel board!

Unfortunately, the sheet contains sensitive data so I can't really post the sheet as an example.

But you could mock up a small dummy sheet, post that (with XL2BB so we don't have to manually type it out) and explain again in relation to that sheet?