Excel programming question

estratosphere

estratosphere

estratosphere

Associate
Joined
12 Nov 2002
Posts
683
Location
Swansea
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.

:)
 
Easiest thing to do would be to do a query in the db and then import the results into Excel.

You could set the job to run once a night or something and then just have him open the file when he wants it :)
 
The words 'Database' and 'Excel' should never appear in the same sentence. never ever. ever.

Access is fine for small amounts of data, so it's probably easiest to import the spreadsheet into there and run a query to do what you need to.

*edit*
doh, i didn't read solar's reply and pretty much ended up saying the same thing :)
 
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?
 
You could put a macro in the spreadsheet, so the macro runs a query/code everytime you open the excel file. That would be easiest.

Should be failry simple to code as you just need today's date + 6 months and then do a lookup on the Students. You could then stick them in a messagebox and a sheet.

Oh and don't bother with access - you have all you need in excel for this.
 
How about some conditional formatting?

Highlight the row red if todays date > pass date + 6 months
 
WIBSBOT said:
You could put a macro in the spreadsheet, so the macro runs a query/code everytime you open the excel file. That would be easiest.

Should be failry simple to code as you just need today's date + 6 months and then do a lookup on the Students. You could then stick them in a messagebox and a sheet.

Oh and don't bother with access - you have all you need in excel for this.
Click to expand...

Quoted for truth!

Best answer, and most sensible to this solution. Why bother with an additional application when Excel can do it for you with ease.
 
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
 
You must log in or register to reply here.
Back
Top Bottom