Organize data into sheets by Date

cyanidepwns

New Member
Joined
Sep 14, 2010
Messages
1
Greetings!
I've got some timesheet data:
9/7/2010 661 minutes 11.02 hours 11.02 hours
9/7/2010 661 minutes 11.02 hours 11.02 hours
9/7/2010 661 minutes 11.02 hours 11.02 hours
9/8/2010 475 minutes 7.92 hours 7.92 hours
9/9/2010 445 minutes 7.42 hours 7.42 hours
9/9/2010 445 minutes 7.42 hours 7.42 hours
9/10/2010 575 minutes 9.58 hours 9.58 hours
9/10/2010 575 minutes 9.58 hours 9.58 hours
9/10/2010 575 minutes 9.58 hours 9.58 hours
9/13/2010 530 minutes 8.83 hours 8.83 hours
9/13/2010 530 minutes 8.83 hours 8.83 hours
9/13/2010 530 minutes 8.83 hours 8.83 hours
9/14/2010 145 minutes 2.42 hours 2.42 hours
9/14/2010 145 minutes 2.42 hours 2.42 hours
9/14/2010 145 minutes 2.42 hours 2.42 hours
9/14/2010 145 minutes 2.42 hours 2.42 hours
9/14/2010 145 minutes 2.42 hours 2.42 hours

And I'd like to create a macro that splits the whole rows of data into separate sheets.
So there's a sheet '9/7/2010' with those 3 rows in it. Then another sheet '9/8/2010' with that one row. Then another sheet '9/9/2010' with those two rows of data. And so on for all the rows of data in the first worksheet.

Can anybody write up that macro for me?
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Forum statistics

Threads
1,223,214
Messages
6,170,772
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top