Hi Christa,

Perhaps you could use Excel's built in Autofilter feature.

See also Ron de bruin's EasyFilter addin which may be freely downloaded at:

http://www.rondebruin.nl/easyfilter.htm


---
Regards,
Norman



"Christa" wrote in message
...
I need to be able to collect data based on date requirement (anything in a
particular month). Can I do this with a macro?