Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a worksheet with 4 columns and about 600 rows. The A,B,C columns have
contents in all their cells. Only a few cells have contents in Column D. What I need to do is to delete all the rows with it's respect D column cell blank. In other words, I am going to just keep all the the rows only when their D column cells have contents. It would be impossible to inspect each row to see it's column D cell is blank and delete the row. Could anyone provide me with a solution, maybe it's just a simple macro. But it has mystified me for 2 days now. Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting Rows in MS Excel | Excel Discussion (Misc queries) | |||
stop users from deleting rows | Excel Discussion (Misc queries) | |||
Deleting rows in a macro in Excel | Excel Discussion (Misc queries) | |||
Question about deleting rows from sorted linked worksheets | Excel Worksheet Functions | |||
Deleting rows containing common data | Excel Discussion (Misc queries) |