View Single Post
  #1   Report Post  
Umesh Banga Umesh Banga is offline
Junior Member
 
Posts: 13
Unhappy Macro - Delete Rows with specific text

Hi,

I want have the following types of table

Total Inflow 82,437 25,921 26,294 27,272 28,455


Cheryl 0 0 0 0 0
Pension 0 0 0 0 0
Total Outflow 81,475 25,625 26,275 26,925 27,600

I want to delete the rows which includes all zeros - can someone please tell me the coding of doing this. Note- in the above table row starting with "cheryl" and "pension" should be deleted.