Monthly Extractions

Hello,

I have a worksheet "data" with over 2000 rows of data from Column A to Q. Column L has a start date beginning from Jan 1 2008 until the present day. For every new incident an entry is made in the data worksheet only.

I have 12 seperate monthly worksheets from Jan - Dec.

Based on the start date month (L2) how do I take only the January data set and put it in the Jan worksheet, begining always from B8? Repeat previous step for each consecutive month data set and placed into the respective month worksheet.

Thanks!

I don't know what you mean by always from B8, but would a pivot table accomplish what you are trying to do?

The data extracted from the "data" worksheet needs to be placed into each respective monthly worksheets beginning in B8. Therefore, all extracted data from Column A to Q will start from B8 within each of the monthly worksheets. Can this be done without Pivot tables? Thx