Excel VBA and deleting rows

[Ironman]

Hello Excel/VBA masters!!!

I have an excel spreadsheet that contains about 1000 rows and about 25 columns. The file contains employee information, name, id, cost center, department, title, FTE...etc. Column E contains the cost center which is a 7 digit number (i.e. 8001234). Within the 1000 rows of data there somewhere to 70 cost centers. I would like to delete all rows where a cost center does not match a list of 13 cost centers. I'm thinking I need some kind of array where I type in the 13 cost centers in the code, but I'm unsure of the syntax within VBA.

Also, the second step of the code I'm looking for is to delete all columns except for Column B, E, J and L. Those, by the way are Name, Cost Center, Job Title and FTE.

Any suggestions would be great!! Thanks...!

[shg]

You could use a formula in an added column to lookup the cost center, and filter to remove those that fail.

[Ironman]

Morning...Yes, I gotcha...that should work out just fine. Thanks for the idea...