LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 2
Default Drop-Down References a Grouped Item - how to populate multiple

I have a list of users and which groups they report to:

User1 Group1
User2 Group1
User3 Group2
User4 Group2
User5 Group2
User6 Group1
User7 Group2
User8 Group3
User9 Group3

I need to be able to select the group from a drop down, and then show ALL users in that group.

Here's how I picture it:
Group 1 (dropdown selection)
User1 User2 User6
### #### ####
xxxx xxxxx xxxx

And the users should change as you change the group name, and then populate their information using VLOOKUP or Index(Match).

Right now my reference table has Agent with his/her related Group, and then a separate list of groups just for the drop down (if I use the Agent-Group column, it returns each group name multiple times in the drop down)

Any help at all would be appreciated!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How remove invalid references in ToolsReferences drop down box? [email protected] Excel Programming 1 July 7th 09 09:52 AM
Populate Multiple cells when choosing one selection from drop down MMANDIA Excel Discussion (Misc queries) 9 December 3rd 07 11:54 AM
Populate Data w/ Multiple Drop-Downs Tiffany Excel Discussion (Misc queries) 1 August 28th 07 07:54 PM
multiple item entries from drop-down list sgoldstand Excel Discussion (Misc queries) 3 May 24th 06 06:25 PM
Pivot Item: removing non-existant item from the drop down CinqueTerra Excel Programming 2 February 23rd 06 08:47 PM


All times are GMT +1. The time now is 06:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"