find the cells that represent a code in one cell
 

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

find the cells that represent a code in one cell
 

Try DataFilterAutofilter 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

On Tue, 29 Jul 2008 09:03:00 -0700, shane
wrote:

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