• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

drop down selection

rupal1234

New Member

rupal1234

New Member
Your solution is very interesting thankyou.
Now i need some changes like if i select A4 dropdown For 2.5 then insulation should also be change like D14 Pvc 13 and XLPE 8 from the dropdown and if i select A4 dropdown For 1.5 then insulation D4 PVC 8 and XLPE 6 from the drop down
 

Attachments

bosco_yip

Excel Ninja
Your solution is very interesting thankyou.
Now i need some changes like if i select A4 dropdown For 2.5 then insulation should also be change like D14 Pvc 13 and XLPE 8 from the dropdown and if i select A4 dropdown For 1.5 then insulation D4 PVC 8 and XLPE 6 from the drop down
upload_2018-11-14_18-32-48.png

1] Please refer to my post #.5, I have mentioned E4 is a Validation dropdown list, and should be clicked to check after selected the cable size in A4.

2] How to do it also stated in row 15-18 (see above extracted picture)

Regards
Bosco
 

rupal1234

New Member
B
View attachment 56462

1] Please refer to my post #.5, I have mentioned E4 is a Validation dropdown list, and should be clicked to check after selected the cable size in A4.

2] How to do it also stated in row 15-18 (see above extracted picture)

Regards
Bosco
But it is showing error like you cannot use references to other worksheets or workbooks for data validation criteria
 
Top