Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting unwanted rows
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting unwanted data | Excel Discussion (Misc queries) | |||
Deleting unwanted and empty rows.... | New Users to Excel | |||
Deleting unwanted and empty rows... | Excel Discussion (Misc queries) | |||
Deleting unwanted Cells | Excel Discussion (Misc queries) | |||
Deleting Unwanted Files | Excel Programming |