Any help will be appreciated for this newbie.
For my purposes, I must have a macro.
I need this macro to go through rows of data. The amount of rows is unknown and sometimes there are blank rows.
The macro needs to take Today's Date and subtract a date in column C to get the difference in days.
*Note: the dates in Column C are values and Column C is formatted as general.
If the days are greater than 30, then the entire row's contents will be cleared (not deleted).
I think I need some kind of loop to run until there are no more rows of data (but I haven't been able to get it to work yet).
The data will look something like this:
______A________________B_______________C____________________
1 ____info _____________info____________ 10/14/2012
2 ____info _____________info____________ 10/01/2012
3
4 ____info _____________info____________ 06/14/2008
5 ____info _____________info____________ 01/31/1999
6
7
8 ____info _____________info____________ 10/19/2012
9 ____info _____________info____________ 03/21/2012
Bookmarks