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)
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!