i am working on a project at work and am ok with excel - not wonderful.
I have staff who can work in many different departments. I have thier names in a drop down list on one workbook, but would like the areas they can work to auto populate from another source (excel) to the right of thier name when i choice thier name. Is this possible and how would i accomplish this? Thanks -