spartan1685
New Member
- Joined
- Jul 18, 2007
- Messages
- 3
hey all,
I am trying to figure out how to do this one part of my excel sheet.
I have roughly 5k in rows containing unique info. I assigned a unique letter to each group ie aa, b, ccc, etc. and each name in the group gets a numerical value 1, 2,3, etc
I first ask for the user to input a department then input a group.
If they give me that information how can i lookup in that particular group to display user names. so say in group x there are 5 names and i want to give the user a drop down to let them choose one of those 5. any thoughts?
i greatly appreciate help in advance...
I am trying to figure out how to do this one part of my excel sheet.
I have roughly 5k in rows containing unique info. I assigned a unique letter to each group ie aa, b, ccc, etc. and each name in the group gets a numerical value 1, 2,3, etc
I first ask for the user to input a department then input a group.
If they give me that information how can i lookup in that particular group to display user names. so say in group x there are 5 names and i want to give the user a drop down to let them choose one of those 5. any thoughts?
i greatly appreciate help in advance...