Moving rows to new worksheets by date

[aaron1000]

Hi Folks, I need some help to automate the following process. I have many thousands of rows of data and I need to break it up into one worksheet per date containing all the rows for that date.

For example:

Source worksheet->
19981125,145800,2830,43
19981125,145800,2830,43
19981125,150000,2830,43
19981127,145500,2850,220
19981209,154700,2830,86


This source is broken up into a worksheet for each day...containing all rows for that day ->

Worksheet[1]
19981125,145800,2830,43
19981125,145800,2830,43
19981125,150000,2830,43


Worksheet[2]
19981127,145500,2850,220

Worksheet[3]
19981209,154700,2830,86


I've had a go at creating vba code for this but I'm not very good at it and have been unsuccessful to date.

Any help will be greatly appreciated!

cheers
Aaron

 

[VoG]

Take a look at Excel Explosion http://www.datapigtechnologies.com/freeware.htm

 

[aaron1000]

Thanks VoG....it works like a champ!

cheers
Aaron