Deleting rows meeting certain criteria in a particular column



I am trying to delete the entire row that meets cetain criteria.
The first criteria is a blank cell in column B
The second criteria is if the cell in column B contains "tot" or a prompt to
enter the criteria.

Any help is very much appreciated.


מיכ×ל (מיקי) ×בידן

You may use "Auto-Filter' or 'Advanced-Filter'.
After filtering you can copy/paste the remaining [visible] records to
another [lower] range/location and delete the original source records.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question