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?
--
Bill

Have you tried selecting the range and then doing data|filter|autofilter?

You can hide/show columns by using the dropdown arrow in each header cell.

You can filter on a custom criteria (= the first of the month and <= the last
of the month).

==
As an aside, you might find that if you put all the data in one worksheet
(adding an indicator column for each shift) will make it even easier. You could
just filter by that column first.

Bill wrote:

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?
--
Bill

--

Dave Peterson