I had attach a code which i edit....

not sure hw i m going to explain


this is what i plan to put in my excel list....

WHen i choose any type on the RED highlighted,
colume A-F, H-M will be filled in automatic


but than i m not sure how am i going to key in on the one which highlighted on Orange..

can some1 advice me... i been search online to check how m i going to fill it but than... unable too