Kmahraz
Member
Hi:
Looking for some assistance with the items below :
Request 1:
Drop down (Distributor won't work )
Request 2:
Based on distributor name selected I would like the Case number to be generated automatically looking something like ((Distributor name- Case number - year)) exp.
Lucky-0001-15.
Bear-0002-15.
Eagle-0003-15
Deer-0004-15.
....
...
.
Request 3:
Case number will be saved in column A.
Request 4:
I would like the data to be saved in sheet (Customer Info), currently it save in the active sheet.
I did some of the coding' just looking for some help and guidance/ suggestions.
Any help will be greatly appreciated.
Please see attachment
Best,
K
Looking for some assistance with the items below :
Request 1:
Drop down (Distributor won't work )
Request 2:
Based on distributor name selected I would like the Case number to be generated automatically looking something like ((Distributor name- Case number - year)) exp.
Lucky-0001-15.
Bear-0002-15.
Eagle-0003-15
Deer-0004-15.
....
...
.
Request 3:
Case number will be saved in column A.
Request 4:
I would like the data to be saved in sheet (Customer Info), currently it save in the active sheet.
I did some of the coding' just looking for some help and guidance/ suggestions.
Any help will be greatly appreciated.
Please see attachment
Best,
K