Hiya,

So every 30 days we have to complete a set of tasks. People are checking the spreadsheet each day for each task to see if the 30 days has come yet (there are maybe 500 rows of data). This makes no sense. It's time consuming, but with the way the tasks are scheduled and set up, we can't use a calendar etc. (too much to get into).

So I'm looking to:

1. Have a macro scroll through a list of dates in column H
2. Once it has determined one (or any) of the dates has hit the 29 day mark, send an email
3. Have information from column A and B in the body of the email (they'll need to know the details of the task)

Is this too much to expect from a macro? Would I need to run the macro myself, or could I have it auto run each morning (I'd prefer the auto run, so it'll do it on the weekend when I'm not around too).

I appreciate any and all help!

J