why not use the built in Pivot Table capability found under the Data menu.

It will do what you want.

--
Regards,
Tom Ogilvy



"Gert-Jan" wrote:

Hi,

I'm looking for a way to do the following:

I have a sheet with (100) rows; in colom A there are values that are not
unique. The word "apple" kan appear three times, for example. In colom B
there are also values, as much as there are in colom A.
What I want is the following: a macro that searches for the word (for
example) "apple" and copies the values from the row in colom B to another
sheet, range D1.

Any help would be appriciated.