Export Rows to New Workbook Based on Date

[mattman123]

Hello all,

I have 30,000 rows of data over a period of three years. I need to export the data week by week to 156 new workbooks. Can someone please assist with a macro that does this?

The data begins on March 1st, 2010. So, the idea is to pull columns A:DA for March 1st-7th in the first new workbook. Then 8th-14th in the second. 15-21st in the third and so on.

For reference, March 1st, 2010 is 40238, and the date is in column is O. Looking to pull all columns to a new workbook and save it when the value of the cell in column O is in between date range for all 156 ranges.

Thanks for reading!
Matt

[hohlick]

Is your data sorted by date?
And, also is one row of data for each date, or there can be multiple rows with the same date?

[mattman123]

It can be sorted by date if that is helpful. Also, there are multiple rows with the same date.

Thank you hohlick!

[mattman123]

Actually, the date range is April 1st 2010 - March 31st 2013.