asked on

VBA Search for strings within Excel

Dear All,

I need some help writing a VBA macro function that can search for a particular string within a worksheet and move the rows containing the search string to another worksheet within the workbook.

Example Search String Hammer

Data rows
Hammer1
Car2
Hammer3

I want the function to move row 1 and 3 of the above data to worksheet3

Any help is appriciated

ASKER CERTIFIED SOLUTION

Rgonzo1971

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Saqib Husain

Does this have to be a macro? If not you can simply use data filter to achieve this.

Jacques Geday

Is this what your looking for ?
Make sure you activate macroes and press on the button and put any complete item or even part item from the ones that exist (just to try first) also you can spot dates and part dates ... you will be given a choice to move the item or not ... they will be moved to Sheet3.

As a start try the string w b then put some capitals it is also not CAPS sensitive we can change that.

Pls try and let me know if it suits you.
gowflow
SearchNMove.xls

Jacques Geday

uff !!! I guess my work went ....
zapooo !!!

Anyway good for whoever search for similar issues as not to obvious to move rows and keep looking for more as you can see in the file I posted.

gowflow

Nicholas Xerri

ASKER

Thank you all for the help

Jacques Geday

your welcome but I guess you closed the question after I posted mine.
gowflow