J
jgmiddel
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.
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.