chem101
11-10-2010, 09:45 AM
Hello Everyone,
Is it possible to restrict data selected in one field based on items selected in another? I have two cells on a spreadsheet. Both have a drop down list of items set up through Data Validation. The drop down list for the first cell contains these items: A, B, C, AA, BB, and CC. The second cell has a drop down list with several items (too many to list here). The items in this second drop down list end in either SY or SW (ex:150SY or 250SW or ERT350SY). Item in list one A, B, C can only be paired with items from list two that end in SY. Items from list one AA, BB, and CC can only be paired from the items in list two that end in SW. Can these input restrictions be put in place using VBA code? If so, can you help me with this?
Thank you for any assistance you can provide!
Is it possible to restrict data selected in one field based on items selected in another? I have two cells on a spreadsheet. Both have a drop down list of items set up through Data Validation. The drop down list for the first cell contains these items: A, B, C, AA, BB, and CC. The second cell has a drop down list with several items (too many to list here). The items in this second drop down list end in either SY or SW (ex:150SY or 250SW or ERT350SY). Item in list one A, B, C can only be paired with items from list two that end in SY. Items from list one AA, BB, and CC can only be paired from the items in list two that end in SW. Can these input restrictions be put in place using VBA code? If so, can you help me with this?
Thank you for any assistance you can provide!