View Single Post
  #1   Report Post  
KimStarbase
 
Posts: n/a
Default Data Validation - 2 items for the same drop box

What I am trying to achieve is a drop down list that would look something
like this:

D1a - suipplies
F1g - cell phones
C2a - travel
E4b - computers

and so on and so forth. I can do that.
What I would like to happen though is in the same cell that the drop down
box is in (a29) I would like to select one of those options and only have
D1a, or F1f, ect show up in the cell. The words are just references to my
budget, and I don't nned them after I selected the right one. Is this
possible?
I am somewhat new to excel and have never went into the visual basic editor
and I don't have clue on how to use it.
Thanks for all your help