macro - delete rows based on multiple criteria.

Hi

I have a large spreadsheet with many rows (around 4-10000). There are some rows which I need to delete based on specific criteria.

Rows that have a value in Column B of "P16252,P16253,P16254,P16255,P16256,P16257,P16258,P16259)

Rows that either have values in Column J of:

Receiving

I also want to delete any rows that contain the following words in Column J.

Accrual
Prepayment
Dynamic

I thought about using the autofilter, but started getting complicated when some of the cells didn't have specific values but contained text that identified they shoudl be deleted.

Any help would be greatly appreciated.

Thanks

Chock

thanks, yes. Any row that has the entries of P16252 to P16259 in column B should be deleted and if there are any values matching Receiving or have certain words contained in the cell value should also be deleted, these values would be found in Column J.

Hope that makes sense.

Thanks

Chock

FWIW:

Please Login or Register  to view this content.