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

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.

Delete all rows that have 0 values in col E
Xbox-2309-1001-3-0 - Download - Digital stores
//192.168.l.0 - Guide
Summertimesaga-0-20-16-pc - Download - Adult games
Based on the values in cells b77 ✓ - Excel Forum
Can't delete mail.com account - Internet & Social Networks Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

,">"&0),"") at the end of a countif formula

help me to add particular cells

Diskette Drive 0 seek failure (error message)

Clear cell contents based on value of another cell range using VBA

My Snapchat is not deleting

Similar discussions

Subscribe To Our Newsletter!