Excel programming question

[estratosphere]

OK so my father comes to me the other day with an Excel dilemma.

He has a database of students which has all of their pass dates for their courses, and all of their personal information included within it.

He wants to have Excel flag up any of the students that are due their reassessment in 6 months time.

How can you get Excel to flag up people each time you open it?

Any ideas would be greatly appreciated.

 

[estratosphere]

ok just to clarify...

all of the information is currently in excel. so i should export it to a table in Access and then set up a query?

What type of thing would be in the query?

 

[estratosphere]

so what kind of thing would i need to put in this macro? cos i'm nmot really sure how to tell it to add 6 months to the date. the checking against would be easy but telling it to calculate the date plus six months it what i am unsure about

 

[estratosphere]

anyone?