I used another program with user programmable aspects to do the same thing i want here. I have a named range "BarSize" that contains a column
with #3, #4 etc... I used Data Validation to Create a dropdown list. I need another cell to equal the "Weight" of the barsize selected. the code i
used is similar to:
I just don't know how to make it work in Excel 2010. I'd appreciate any help!
Please Login or Register to view this content.