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
Bookmarks