Hello,

I have a column which has about 500 unique entries in it. The entries
are business sector types, and I need to be more general so need to
have about 10 business types instead of the 500 odd.

In a second worksheet I have copied the column containing business
types, I have then run the remove duplicates on it - which has got the
size down to the 500 unique values.

Along side each of these values in the second column I have written the
value I would like to replace the initial value with in the original
worksheet.

How do i tell excel to replace all values in worksheet-1, column E,
that match the value in worksheet-2 ColumnA, with the value in
worksheet-2 Column B?

e.g.

worksheet-1
Column E
a
b
a
c
d
a
e
f
h
g
h
h
i
j
.....


worksheet-2
Column A Column B
a a
b a
c a
d a
e b
f b
g b
h b
i c
j c
...

The result im looking for when the macro is run, is an updated column
E, in worksheet-1 that would like this.

worksheet-1
Column E
a
a
a
a
a
a
b
b
b
b
b
b
c
c


Thankyou,
Gary