| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to find data validation in a cell | Excel Discussion (Misc queries) | |||
| Defining identical names that represent different ranges of cells | Excel Discussion (Misc queries) | |||
| How do I get a number or letter to represent cell contents? | Excel Discussion (Misc queries) | |||
| What does the 8.43 and 12.75 represent in height and width of cell | Excel Discussion (Misc queries) | |||
| Find the cell value in excel by using vb code | Excel Discussion (Misc queries) | |||
Hybrid Mode
