Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 14th 18, 06:28 PM
Junior Member
 
First recorded activity by ExcelBanter: May 2018
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!

  #2   Report Post  
Old May 14th 18, 07:11 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,604
Default Drop-Down References a Grouped Item - how to populate multiple

Hi,

Am Mon, 14 May 2018 18:28:12 +0100 schrieb SoozTX:

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


have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgc5Zhw4uK0WjFTctSw


Regards
Claus B.
--
Windows10
Office 2016
  #3   Report Post  
Old May 14th 18, 08:06 PM
Junior Member
 
First recorded activity by ExcelBanter: May 2018
Posts: 2
Unhappy

Firewall is blocking
  #4   Report Post  
Old May 14th 18, 09:20 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,604
Default Drop-Down References a Grouped Item - how to populate multiple

Hi,

Am Mon, 14 May 2018 20:06:56 +0100 schrieb SoozTX:

Firewall is blocking


send me a mail to
claus_busch(at)t-online.de
Then I will send you the workbook via mail.


Regards
Claus B.
--
Windows10
Office 2016
  #5   Report Post  
Old May 15th 18, 08:21 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2018
Posts: 6
Default Drop-Down References a Grouped Item - how to populate multiple

On Tuesday, 15 May 2018 05:49:06 UTC+12, SoozTX wrote:
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!




--
SoozTX


A dropdown selector can be created by applying Data Validation to a cell. You need to create a list of the groups first. Then apply Data Validation to the dropdown cell and use the List option. Now you can use the value of this cell to select rows from your data table. If you add a "selected row number" column you can then use VLOOKUP to compress the selected rows into a contiguous range.


Reply
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 02:24 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017