Split, sort and mail

[splat]

I have a list A1 - J1500. Column J is dealer name. B is inventory
item, C is description, D is quantity). I need to copy all dealer A
entries (in sheet 1 only column B,C and D) to sheet 2. Dealer B to
sheet 3 etc.
I need to keep Sheet 1 intact at all times.

I will then need to email sheet 2 to dealer A, sheet 3 to dealer B
once a week. (if possible)

Could I ask for as much detail as possible please.

Any help will be really appreciated.

I am using 2007.

 

[Mike Fogleman]

Here is about as much detail on sending mail from Excel as you need:
http://www.rondebruin.nl/sendmail.htm
Sending it on a set schedule would be best managed by you, not Excel.

To get a unique list of dealers use Advanced Filter on column J and copy
unique list to perhaps column M. This is your Sendto list. Use a loop within
a loop to match each name in column M to each name in column J. When a match
is found, copy the Offset values from J to the next row of the appropriate
sheet.

Mike F