Looking for a genius.

S

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