Auto alert or auto print on due date

[robbo747]

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

[royUK]

You can highlight dates using Conditional Formatting

http://www.excel-it.com/excel_condit...formatting.htm

You could use VBA to test for specified dates & print sheets or send emails. Attach an example of your data layout if you want sample code.

[robbo747]

You can highlight dates using Conditional Formatting

http://www.excel-it.com/excel_condit...formatting.htm

You could use VBA to test for specified dates & print sheets or send emails. Attach an example of your data layout if you want sample code.

Thanks for the response Roy - looking good then!

Still need to produce the original document and have to do some research to get all aspects covered - but I'll do all that and get back to you!