Hi all,
sheet 1
Col A1= Employee L name (drop down list)
Col B1= Employee F name
Col C1= Month
Col AF= A list of employees L names
Col AG= A list of employees F names
Sheet 2 holds employees records
I have 6 employees with the same last name, when I click A1 I can pick "Garcia", or "Miller" or "Flores", how can I make B1 list the F name that goes with the L Name. Attached is example sheet
thanks for the help
'DEPENDENT DROP BOXES
These are called Dependent Drop Down lists and they use named ranges and INDIRECT() references in the proceeding drop boxes.
Here's a sample sheet I've posted showing how it's done. The sheet "CHOICES" has the dependent drop lists (and shows one of the dangers of using them) and the sheet "LISTS" shows the lists and named ranges in use.
Have a look.
Sample Files
DependentLists3.xls 3 levels
DependentLists2.xls 2 levels
DependentLists-SelfSorting.xls Self-Sorting lists of fruits by color choices
More reading:
http://www.contextures.com/xlDataval02.html
http://www.contextures.com/xlDataVal13.html
'Unique Values from Repetitive data in a drop box
http://www.excelforum.com/attachment...dationlist.xls
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks