I'm attempting to setup a worksheet for reminding employees to renew
their licenses. I have input the data where the data range is from row
3 - 84 (this could increase or decrease with hiring/firing, etc.). The
columns range from A - K with column H being *date*.

I would like to start a new sheet (sheet2) in this workbook with the
range of months in a year. In each monthly section it would search the
data range in sheet 1 and return the records with the corresponding
dates for that month. For example: If a employee's license expires in
January, the entire record for that employee would be displayed on sheet
2 under January.

I'm pretty new at this. At first I used the AutoFilter which provided
reasonable results but I would work a lot better if I could display on
one sheet the employees that need to renew their licenses on a month by
month basis.

Thanks,
Nathan


--
redbna
------------------------------------------------------------------------
redbna's Profile: http://www.excelforum.com/member.php...o&userid=24125
View this thread: http://www.excelforum.com/showthread...hreadid=377466