G
gojakie
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?
(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?