Hi all;
I am working on a project,i need to create a combo box that the values that must be in combo box is in another sheets,let me describe the example,I have a sheet named "IPE" & another sheet is "IPB" and... and a sheet named "calculating capacity".
I want to calculating capacity for some beams, for example some beams are with plate some are without plate, some are doubles and some are singles,some beams are IPE some are INP and some are IPB,
i want the user make beams based on these,for example a beams made by a single ipe and withplate...so the user must select IPE and single and withplate
then i need to create a combo box based the selection of user, for i.e. if he select IPE then in the column"Section" a combo box appear based on sheet"IPE"(i.e. in combo box will conclude IPE100,IPE120,IPE140,...)
or if he select "IPB" the in the column"Section" a combo box appear based on sheet"IPB"
(i.e IPB100,IPB120,...)
Bookmarks