mlhwhite007
New Member
- Joined
- Oct 26, 2006
- Messages
- 1
I’m creating a macro to reformat data in a report. I would like to create a loop in the code that looks for a specific value listed in column F and compares it to a corresponding date in column G to determine whether or not to delete the row.
For example: If F6 equals “Interview-Rejected”, and G6 (date) is greater than system date plus 7 days, then delete row 6. This loop should run until it gets to a blank row in Column F.
Thanks!
For example: If F6 equals “Interview-Rejected”, and G6 (date) is greater than system date plus 7 days, then delete row 6. This loop should run until it gets to a blank row in Column F.
Thanks!