Delete all rows that have 0 values in col E [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I have invoices that have all employees listed. I am looking for the easiest way to delete the employees that have "0" entered in column E. (meaning there is no charge for them on that particular invoice). This applies to numerous invoices so a macro would be wonderful.



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
761
Filter the sheet for 0
delete all the visible rows
unfilter


IF you record your action, you will get a macro too

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!