Hi everyone,
I am trying to create a macro which deletes a column aside from those titles specified in a header. However, I would like to delete everything in that column only from Row 9 and down (I would like to leave all the information above row 9 untouched).
For example, the headers I want to keep are (Dog, Cat, Cow, Sheep, Duck)
Column A B C D E F
Row 9 Dog Cat Cow Sheep Table Duck
I would like to delete all of column E, but only from row 9 and below. Any information I have above row 9 would not be deleted.
Any help would be great! I tried using a macro that was suggested here by MarvinP:
http://www.excelforum.com/excel-prog...d-headers.html
It works great, but deletes everything in the column, and I would like to delete only information from row 9 and below.
Thanks!
Bookmarks