| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing unnecessary rows through macro
I have data in column E which consists of names. some rows have data
(names) and some does not (blank). I want to delete all rows where column e has blank cells and where the data = "header". For instance, lets say the column E looks like this (Range E1:E23) header name1 name2 name3 header name4 name5 name6 header name7. The desired output i want is like this (Range E1:E7) name1 name2 name3 name4 name5 name6 name7 The last row is unknown, we therefore need to identify the last row first and then run the macro Can somebody help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Unnecessary Rows | Excel Discussion (Misc queries) | |||
| Macro for removing columns/rows, freezing panes etc? | New Users to Excel | |||
| removing unnecessary spaces from multiple cells | Excel Worksheet Functions | |||
| Removing rows via macro/VBS script | Excel Programming | |||
| Removing Unnecessary Macro Security Warnings | Excel Discussion (Misc queries) | |||
Threaded Mode
