Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for deleting rows and serialising the remaing rows | Links and Linking in Excel | |||
Macro for deleting rows and serialising the remaing rows | Setting up and Configuration of Excel | |||
Macro for deleting rows and serialising the remaing rows | Excel Worksheet Functions | |||
Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions |