Start out by looking in the vba help index for FINDNEXT
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Galway" wrote in message
...
I need a macro. I have two columns. One with various text (column A,
worksheet 2). One with a unique text (column B, worksheet 2). I need a
macro that will search column A and give me the text in column B. Then
Find Next. The same search can find multiple choices from column B. I
want all my Column B choices as my result.

I am starting with (on worksheet 1, a cell with a small string of
text) to be found in Column A on worksheet 2, on worksheet 1 I have a
range of cells set aside for the top ## of results from column B on
worksheet 2.

I hope this is clear.

Galway