View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
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