View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_73_] Steve[_73_] is offline
external usenet poster
 
Posts: 15
Default Delete cell value in ColE based on value is ColA

All,
I have a work sheet with data like this

Col A___________Col B___________Col C___________Col D___________Col E
9812___________ Joe____________________________________________125 .00
*blank*__________
____________________________________________125.00
*blank*__________
____________________________________________125.00
Total __________ ____________________________________________
375.00

What I want to do is delete value in Col E if the value in Col A of
the same row IS NOT = Total


Thanks
Steve