Get information by Month

[shaunburke]

I want to create a worksheet that when I enter in the month will pull all of the trainings for that month.

I'm using the information to Mail merge with a Publisher document (Certificates of completion), so I can't use a pivot table.

Any thoughts?

[wetterinc]

I've played around with it and came up with the following workbook. My experience in programming is very limited so it doesn't look as clean but the basic components are there and it works. Just copy additional sheets as necessary for all months.

The only thing you need to do is add a new column to your "data" tab called Month and sort ascending. You can then run the macro in the Sheet1 or Sheet2 to populate.

[shaunburke]

sorry, I wasn't clear. What I need is when I type in the month, I get the list of all the trainings conducted by month. My attachment is an example of what I want the result to be.

[wetterinc]

You can control the month in Cell A1, then run the macro.

As far as something that is totally automated... not sure how to get that accomplished.

[shaunburke]

Didnt see the macro. cool, works perfectly...thanks