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:
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 criteria