find the cells that represent a code in one cell

[shane]

I have assigned occupational codes to job titles. One code can refer to more
than one job title.

I want to be able to list all the job titles = to an occ code on another sheet

 

[Gord Dibben]

Try Data>Filter>Autofilter on code number then copy visible cells to the
other sheet.

To automate see Ron de Bruin's site for macros.

http://www.rondebruin.nl/copy5.htm


Gord Dibben MS Excel MVP