C
charles.w.price
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
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