extract relevent data information in other cells

hi,

i have a wookbook that has codes in a range of cells. the codes could very in each cell evey time i run the macro

there are 20 different codes and discriptions.

each code has a description with it
each code could repeat itself when i run the macro
i want to be able to put the relevent discription once with the code even if the code has repeated itself

ie

a=apples
b=beans
p=pears
etc

a1 could have "a" in it
a2 could have "a" in it
a3 could have "b" in it
a4 could have "p" in it

i would like to see a matrix that just shows the code description once if the code is in the column a

the codes in cell a1,a2,a3,a4 could change the next time i run the macro

hope this helps
thanks

steve

hi,

if possible i want only one of the codes and discriptions to appear apear at the bottom of the page. this will represent the others if more than one of the same code appeared
ie if apples appeared 3 times.i want to only show it once

hope this makes sence

As in the function provided by highlighting the data, then Data, Filter, Advanced Filter, Copy to another location, Unique Values only ?

Originally Posted by stevekirk

hi,

if possible i want only one of the codes and discriptions to appear apear at the bottom of the page. this will represent the others if more than one of the same code appeared
ie if apples appeared 3 times.i want to only show it once

hope this makes sence

hi,

thanks bryan all working great

steve