Depending what your source data looks like I would suggest using a pivot
table. By using the show pages feature it will create all of the seperate
sheet that you describe. If you want more help persuing this just reply
back...
--
HTH...

Jim Thomlinson


" wrote:

I need help. I have spreadsheets that are automatically created every
month. They have 9 different columns that include Date, Ticket #,
Customer, Job, Truck ID, Product, Gross, Tare, and Net. All this is
in 1 main worksheet.

How could I create a macro that would Separate the different customers
to different worksheets and automatically sort them by date? Also,
what if I have different jobs for the same customer, could I make the
macro separate the different jobs to different worksheets?

One more thing, when the new worksheet is created, could the macro
name the new worksheet by the customer name?

Any help would be greatly appreciated.

Thanks,
Charles