I have an excel file of the form:
ColA ColB ColC ........ ColK Col L .........................
Row4 Name Position Location Start Date Appraisal date
Row5 Person1 Manager Location1 01/Aug/04 01/Oct/04
Row6 Person2 Nurse Location2 08/Aug/04 08/Oct/04
I'm writing a simple html page where the locations will be in a drop down menu, and another menu will contain the 12 months of the year.
What i need is for the user to pick the location and/or month, and what is returned (in any way) is the details of people with the appraisals due in that period.