Delete all rows that have 0 values in col E
Closed
DJ
-
Jun 9, 2010 at 12:29 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 9, 2010 at 12:37 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 9, 2010 at 12:37 PM
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.
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.
Related:
- Delete all rows that have 0 values in col E
- //192.168.l.0 - Guide
- Whatsapp-desktop-2-2401-5-0.msixbundle - Download - Instant messaging
- Xbox-2309-1001-3-0 - Download - Digital stores
- Delete my whatsapp account without app - Guide
- How to delete a row in a table in word - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 9, 2010 at 12:37 PM
Jun 9, 2010 at 12:37 PM
Filter the sheet for 0
delete all the visible rows
unfilter
IF you record your action, you will get a macro too
delete all the visible rows
unfilter
IF you record your action, you will get a macro too