Hi Katerinia,
in another column enter

=INDEX(CODESNEEDED!$A$1:$A$5,MATCH(C1,CODESNEEDED! $A$1:$A$5,0))

I assume that the code in sheet job_codes are in C starting in row 1
If the code is not in the other sheet it will bring #N/A
then filter the column by #N/A, higlight the rows, right click on the mouse,
delete
then go back to the filter and select all



"Katerinia" wrote:

In worsheet JOB_CODES
C1 C2 C3
JOBCODE EFFDT DESCR DESCRSHORT
414096 1011906 DSC VP - REFINERY OPERATIONS DSCVPREFOP
414116 1011906 DSC GEN'L COUNSEL & SECTY DSCGENCNS
414126 1011906 TLNAS PRESIDENT TLNAS PRES
414146 1011906 DSC VP & AST TO PRS-GOV REL DSC GOVREL
415016 1011906 DSC DIRECTOR - INFO TECH&PLNG DIS DIR IT
415026 1011906 DSC VP - SALES DSC VP SLS


The only need to keep certain data rows which are listed in another
worksheet: "CODESNEEDED"

NEEDEDCODES
123500
410013
410014
410023
410227
410407

How can I mark worksheet Job_CODES so I can run a filter and delete the rows
I dont need the info.