You could turn on the macro recorder as you perform the task manually.
Then, edit the resulting code, to make it generic, and run the code each
month as required.

If you need specific help with the code, you could provide more details
about what you're trying to do.

MarcusA wrote:
I have 50 worksheets in a single workbook which all pull data from the same
source document. Being that I need to perform this function monthly, is
there any way to automate the filtering process using a macro?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html