View Full Version : Solved: Data validation or other drop-down with different sheets?

12-15-2008, 03:48 PM
OK I take it from the resounding silence on my last post that I wanted an impossible thing. I can deal with that.

New idea: each employee has 1 copy of one workbook, to which they add their clients. So we have the "Client" sheet that lists all the clients and their demographic info, the "selected client" sheet, and the other forms each in a sheet of its own (Privacy agreement sheet, release of info sheet, etc).

I've attached a file that I hope demonstrates what I want.
In this scenario, can I do the following and how:
Select client's name "Mindy" in the Selected client sheet. This makes Address = Mindy's address, DOB = Mindy's DOB, etc. Now, when I go to Privacy sheet, can I reference the Selected client sheet and make Mindy's info appear? And then does it still work when I return to Selected client and select Mork instead of Mindy?

12-15-2008, 04:36 PM
Like this?

12-15-2008, 06:01 PM
Yes! Yet again, foiled by the simplicity of Excel functions... Thanks mdmackillop!