Separate monthly data to multiple worksheets

[Nashvillbill]

Hello All,

I'm looking for a quick and easy way to take a years worth of information on one worksheet and have it copied and separated out by month on a new sheet (in the same workbook) for each month. Is there an easy macro or function that I can use?

Thanks!
Bill

[VBA Noob]

Hi,

How about a pivot and group by months

http://www.contextures.com/xlPivot07.html

VBA Noob