It sounds to me like an Autofilter (Data -- Filter -- Autofilter)
should work for you. Could be automated with a Macro if desired, but
it works pretty easily without a macro. Once set up, you click the
arrow for the Date column, select your filter criteria, and it hides
all rows that don't meet the criteria.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=376406