Deleting certain rows

[davidhall80]

I get a list every week of 500-600 employees starting in row 15. Rows 1-14 are the heading rows. I than copy that tab and remove all except 26 employees from the new tab. I can't record an if statement because I have to many employees. Is there a way I can delete all rows in Rows 15 to Rows 600 that don't have the following employee ID's. I've only listed a few for the example, but I will use the methodology provided for my larger list.

Employee ID's

569856
365874
369857
365894
365874
365987
698743
359874
365987




The employee ID's are in Column A.

 

[Oaktree]

B15=ISNA(MATCH(A15,D:D,0)) where column D has the employee numbers you'd like to keep.

Copy down, filter column B for TRUE, select rows 15:1000 (or whatever the last row is), press ALT ; to select only the visible cells, and press CTRL - to delete the rows which did not match. Remove the filter and you should have only the desired rows left.

Or, use VBA

 

[onlyadrafter]

Hello,

How about having this list somewhere e.g. J1:J26

in B15 enter the formula

=IF(ISERROR(MATCH(A1,$J$1:$J$25,0)),"N","Y")

and copy downas far as necessary.

you can the filter on column B for Y then copy this where required.

Do you still need a macro?

 

[davidhall80]

Cool gentlemen...... thanks for the assistance