Hello All,
I'm trying to make a drop down list with alpha values (A thru Z) so that if
you select "A", it'll show "A" in the cell but give it a value of 1. Thus
if you select "B" in the dropdown, it'll show "B" however give it a value of
2 and so on.
Anyone have a VBA macro or excel equation that would work for this?
Corey