ya if i select For 2.5 dropdown then it should select 2.5 data which is in cell B14 to j14rupal1234
Seems that You have continued this:
https://chandoo.org/forum/threads/lock-and-unlock-cells-based-on-condition.40059/#post-239878
Why You've copied same macros to two places (also to Module1)?
Where would data come?
Is next step to do if You select from A14 1.5 then something would show in row 4?
Would there be more variations?
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
But it is showing error like you cannot use references to other worksheets or workbooks for data validation criteriaView 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
Is their any solution for this?B
But it is showing error like you cannot use references to other worksheets or workbooks for data validation criteria
this is not working please send me another solutionHere is the link regarding how to create Validation list from another workbook
https://www.contextures.com/xlDataVal05.html
Regards
Bosco
Reread the link contents and follow the steps as per described.this is not working please send me another solution
i am doing the same thing but it does'nt work for me.Reread the link contents and follow the steps as per described.
Contextures is one of the best Excel websites other also doing the same thing.
Regards
Bosco