Solved Trying to substitute names in a drop-down list

Microsoft Excel 2003 (full)
March 2, 2012 at 14:28:32
Specs: Windows XP, 1.0Gb
I am trying to write a drop-own list that will substitute the values within the list. There are three employees who are named "EMP1", "EMP2", and "EMP3". The actual names change as they are not regular hires but are employees on an as-needed basis. When "EMP1" is Smith, "EMP2" is Brown, and "EMP3" is Green, I want the drop-down list to have the actual names. When the actual names change, I want the drop-down list to reflect the new actual names.

Thank you.
Brian W

See More: Trying to substitute names in a drop-down list

Report •

March 2, 2012 at 18:56:42
✔ Best Answer
Your question doesn't make sense, at least not to me.

If the drop down list refers to a range of cells, whatever is in the cells will show up in the list. If you change a cell, the list will change.

What am I missing here?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

March 3, 2012 at 12:22:01
Dear DerbyDad03,

Thank you for your response. Based upon it, I was able to make changes on the drop-down lists to reflect changes in the content of the list's cell references.

Brian W

Report •

Related Solutions

Ask Question