Here is an example using Find/Findnext: http://cjoint.com/?dfs7jLddaF

HTH
--
AP

"damorrison" a écrit dans le message de
ups.com...
I am trying to develop a little VBA lookup program and don't know how
to start:

I have a list of 10 columns
column A will be the column to search through,
Colmn A could also have more than one value that is the same
An input box pops up, the user puts in a value and the program will
search column A find the criteria and then copy and paste the row to
another sheet, continue searching the column, find another match, copy
and paste the row to that other sheet into the next open row.
How does somebody start writing something like this