I am trying to create an order form for my company where there are different options depending on which item is selected.
Say I want to order a cedar 2x4 as opposed to a different kind of 2x4. Cedar only comes in certain sizes and I want my next drop down to only show those sizes. I have followed tutorials online and I keep running into the same problem. I create name ranges first and then set my first drop down box. But then, when I go to set the dependent box there is an error message which says "The Source currently evaluates to an error." This is where I am stuck. Any help?
Say I want to order a cedar 2x4 as opposed to a different kind of 2x4. Cedar only comes in certain sizes and I want my next drop down to only show those sizes. I have followed tutorials online and I keep running into the same problem. I create name ranges first and then set my first drop down box. But then, when I go to set the dependent box there is an error message which says "The Source currently evaluates to an error." This is where I am stuck. Any help?