Romera
New Member
- Joined
- May 12, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi all!
I am stuck with the following problem:
I created a listbox in a form with the option to select multiple items. When hitting the 'Add' button, the selected items are stored in one column in a table separated by a semi-column. However, I would like to filter a Pivottable based on the selected items uniquely.
This is the form I created in VBA (the content is a bit different, but this is the idea):
The problem is that all the items are stored in one column, so I can filter on e.g. "A, B, D" and "B, C, E" instead of "A", "B", "C", "D" or "E" individually.
Is there a way to do so? I tried using PowerQuery to split the columns but this did not work for me either.
I hope someone can help me out, would appreciate every little help
All the best,
Romera
I am stuck with the following problem:
I created a listbox in a form with the option to select multiple items. When hitting the 'Add' button, the selected items are stored in one column in a table separated by a semi-column. However, I would like to filter a Pivottable based on the selected items uniquely.
This is the form I created in VBA (the content is a bit different, but this is the idea):
The problem is that all the items are stored in one column, so I can filter on e.g. "A, B, D" and "B, C, E" instead of "A", "B", "C", "D" or "E" individually.
Is there a way to do so? I tried using PowerQuery to split the columns but this did not work for me either.
I hope someone can help me out, would appreciate every little help
All the best,
Romera