Never written a macro before - need one to be prompted by date

[EmilyDoherty]

Hello all,

I have used Excel for years, and run macros, but never written one myself.

I have a spreadsheet of archived items that I need to review on a weekly basis to ensure boxes get sent back in a timely manner.

The relevant columns are:

Box number (an 8 digit number)
Date recalled
Recalled by (this will be a name)
Date sent back (date - if not sent back, this will be empty)
Review date (this will have a date 9 working days after the date the box was recalled)

My ideal scenario is that I open the s/sheet each week, run my macro which will:

Check the Date sent back box, if it is populated - nothing happens
If it is empty, the macro then checks the Review date box and if the present date is beyond the review date - the macro forms and email to be sent to the name in the Recalled by box stating:

Subject: Box number: (it gets this from the Box number column)

Please note this box was recalled on DD/MM/YY and is still in the office.

Please advise if this can now be sent back - if not please respond accordingly.

This is a big ask, I realise this - and I don't necessarily want someone to do this for me - I ideally want to understand how I do this, so that I can do it going forward myself.

Any help would be greatly appreciated!

Thanks

Emily

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.