0

I'm trying to do the following. I got two sheets on the same worksheet.

Sheet A:

enter image description here        

Sheet B:

enter image description here

When i check the checkbox on the Modules Filter (Drones) i need to fill a list with TYPENAME(Sheet B) that contains only Modules that belong to the "Drones" groupName (Sheet B)

Thx!

  • 1
    You can put a pivot table in Sheet A. And use GroupName as a filter and TypeID as row. For better usage, you can use a slicer. – Oliver Leung Jun 11 '20 at 06:27
  • It doesn't really work out for me to be honest. I would have to manually delete groupNames than i don't use or want. –  Jun 11 '20 at 10:44
  • So, your "Module" filter is the "GroupName" column. Correct? [This](https://i.stack.imgur.com/3C19V.png) is how the pivot table would look like, which is pretty much serve your purpose (except that those are not checkboxes). Please be more specific on which part that didn't work for you (or how you want things to be shown). – Oliver Leung Jun 12 '20 at 04:05

0 Answers0