Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
need to extract data from a few worksheets to another | New Users to Excel | |||
CONVER CSV CUSTOMER DATA TO A CUSTOM INDIVI CUSTOMER PRICE SHEET | Excel Discussion (Misc queries) | |||
extract data from multiple worksheets | Excel Worksheet Functions | |||
Extract Data from Multiple worksheets | Excel Programming | |||
How to extract data from multiple worksheets.. | Excel Discussion (Misc queries) |