J
jeff.white
I have an interesting problem. I have one workbook with two sheets.
The first sheet contains columns A thru U, the about 1600 rows. It is
a list of employees and information about them pertaining to their
job, so, column K has a job code number, 4 digits. Sheet 2 is a list
of 'key' job codes, one column, 68 rows. What I'd like to do, maybe
with VBA is delete the entire row from the first sheet if it's job
code number from column K is not on the list from the second sheet.
So what remains is a list of employess that have those key jobs.
Any ideas?
The first sheet contains columns A thru U, the about 1600 rows. It is
a list of employees and information about them pertaining to their
job, so, column K has a job code number, 4 digits. Sheet 2 is a list
of 'key' job codes, one column, 68 rows. What I'd like to do, maybe
with VBA is delete the entire row from the first sheet if it's job
code number from column K is not on the list from the second sheet.
So what remains is a list of employess that have those key jobs.
Any ideas?