View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
frayer frayer is offline
external usenet poster
 
Posts: 1
Default deleting rows with zero value

Hello, I've an xl file (XL2K-XP) which is an accounting file
worsheets. The sheet "Recap" have 5 colums i.e A.col=accounting items
B.col=details - C.col=amounts in US$ - D.col.=amounts in foreig
currencies - E.col.=amounts details
About 250 accounting items are listed in col.A
This file is filled by various partners with their specifics items
that means that some items have no value (Zero by default).
What I want is when saving the file, all the rows with zero value i
C.col are deleted BUT a problem should arise when the file is save
"blank" before filling it, all the rows will be deleted.

How this could be managed

--
Message posted from http://www.ExcelForum.com