Hi,

First I want to start off by saying thanks to everyone who has helped me so far on this forum!

My knowledge of excel is pretty basic - but I can always find the answers to problems on this forum - QUICKLY!

A special thanks to VBA Noob - quite simply a true legend!


Ok so here's my next topic

When we have new starting employees at work there is a coaching and accreditation period they must past in order to reach 'qualified' status within a certain timescale.

Is there a way I can set up a spreadsheet to help track this?

- so that you are informed when the due date is near or passed?
- auto print a document on a set date?
- be able to enter a date and excel work out the date 4 weeks from that date
- can I maybe set up an email reminder?!
- can print a daily report with an update of what coaching is due

I ideally want to create a 'super' database for 400 employees where all coaching can be recorded and accreditation deadlines/review deadlines listed with an auto-notify function.

I have no problems setting up the layout of the sheet - it's just the functions and programming I will struggle with!

I understand some of this maybe in the realms of fantasy - but I've quickly learned on this forum - EXCEL CAN DO SO SOOOOO MUCH!!!

Any help would be appreciated