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?
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?