Find Multiple Command For VBA in Excell

[Gustavio]

Good day,

I am new to the VBA code for excell.

I am trying to automate a process for my small business.

I am trying to create a macro to find multiple values, one of them is "B00ZL31582".

All i came with so far is:

Cells.Find(What:="B00ZL31582", After:=ActiveCell, LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate



How can i find multiple values all at the same time?
Then select them all, and after select all of the rows in which the value is.

Basically all i want to do is a mass find all on multiple values...


Thank you for your help in advance!!

 

[igold]

You could use a manual or a VBA AutoFilter with multiple criteria. From this part of your post

How can i find multiple values all at the same time?
Then select them all, and after select all of the rows in which the value is.

it seems like you are probably wanting to copy the rows to somewhere else, which an AutoFilter would definitely help with.

Maybe with a drop more info we could find a good solution for your requirement.

 

[Gustavio]

My excel document is representing monthly sales for hundreds of products.

Each products has its unique alpha numeric identifier in a separate rows.

One column is representing one sale and the rows separate the date, shipping address, price, indent.. ETC

I wish to input these identifier in the mass search option & run macro so it can find them and select the rows which they are in.


P.s. I am french, therefore i am sorry if my English is rough!