Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet with amounts that start in column C and goes through
column AE (columns A & B contain an entity number and an entity name). The number of rows varies, but it is typically about 600 rows of data. This data begins on row 9. Row 8 contains the column headers and the 1st 7 rows contain junk that comes over from the program I download this data from. It can be eliminated if it helps. Basically I am looking for a macro that steps through each row of data and if the sum of column C through column AE = zero, I would like the entire row to be deleted. Does anybody have any ideas? I feel bad because this is the third time I have come to this group for help. Each time the solutions have been terriffic. I keep hoping I can answer a question instead of always asking, but so far all the questions asked have been above my skill level. Thanks, Tim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming |