Hello Excel Guru's
I have a worksheet that has 3 columns.
Column A, Column B and Column C
Long story short I am looking for a Macro that will look at Column C and if there is a blank cell (In column C) delete row.
If you need the long story with more facts to make the Macro work read further.
- There are numbers, text in the rows A2:A100 and B2:B100 for Column A & B, however in the rows C2:C100 under Column C there will only be a date format as such - Date: 01/08/13
- There could be some rows that do not have a date under Column C
- The date will run between : Date: 01/01/13 to Date: 07/31/13
So the rows under column C will either blank or Date: xx/xx/xx (range of dates above)
I would like to have a Macro that will look at column C and delete all rows that are blank.
Let me know if you need anything else.
Thanks in advance.
Bookmarks