I need a Macro to extract data by customer to new worksheets

[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

 

[Guest]

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

 

[charles.w.price]

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

I will at least give it a try. I don't know that a pivot table is
what I am looking for but I will see. What do I need to do?

 

[Ron de Bruin]

You can also take a look here
http://www.rondebruin.nl/copy5.htm

 

[charles.w.price]

You can also take a look herehttp://www.rondebruin.nl/copy5.htm

Ron,
How can I change which column it uses. My data is in column "C"
rather than A. Also, it doesn't rename the new worksheet tabs. Is
there a way to make it do this manually?

 

[Guest]

check out this link...

http://peltiertech.com/Excel/Pivots/pivotstart.htm

 

[charles.w.price]

You can also take a look herehttp://www.rondebruin.nl/copy5.htm

Better yet Ron, How can I make it pop up a question that asks me which
Column I would like it to use? then I enter the column letter and it
then runs the macro.

 

[Ron de Bruin]

If your range start in A and you want to filter on column C

then change

rng.Columns(1).AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=.Range("IV1"), Unique:=True

To

rng.Columns(3).AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=.Range("IV1"), Unique:=True


See the VBA help for application.inputbox
If you need more help post back

 

[charles.w.price]

If your range start in A and you want to filter on column C

then change

rng.Columns(1).AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=.Range("IV1"), Unique:=True

To

rng.Columns(3).AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=.Range("IV1"), Unique:=True

See the VBA help for application.inputbox
If you need more help post back

Ron,

Thanks a lot! I have looked at the help but do not understand how I
would apply the input box. Could you give me some guidance?

 

[Ron de Bruin]

See your new thread