G
Guest
I have a workbook with 3 worksheets each with 6 columns
The worksheets relate to 3 different shifts of employees
each worksheet has 6 columns
name,initial,Staff number startdate, medical due, licence due.
Every month I will need to see a report on whose medical is due in the
following month and when their licence to operate machinery is due for
renewal.
The report should be on a further worksheet in the same 6 column format
Of course I can sort in date order and visually scan but thought there
should be a way of doing this by creating a search and report macro.
I've looked at V(H)Lookup but I don't think this fits the bill.
I have considered Access but our computers don't have this functionality.
Is there any hope?
The worksheets relate to 3 different shifts of employees
each worksheet has 6 columns
name,initial,Staff number startdate, medical due, licence due.
Every month I will need to see a report on whose medical is due in the
following month and when their licence to operate machinery is due for
renewal.
The report should be on a further worksheet in the same 6 column format
Of course I can sort in date order and visually scan but thought there
should be a way of doing this by creating a search and report macro.
I've looked at V(H)Lookup but I don't think this fits the bill.
I have considered Access but our computers don't have this functionality.
Is there any hope?