Nailbender31
New Member
- Joined
- Dec 22, 2023
- Messages
- 1
- Office Version
- 365
- 2021
- Platform
- Windows
Hello,
I currently have a data validation list, with a VBA that allows me to select multiple items in one cell. The items selected in the list are the headers of a table. I'd like the headers to be the criteria range used when referencing the cell with my data validation list, to sum the data below that match the list criteria.
The issue I keep running into, is the multiple items in my list are not being read independent of one another.
My data list is in column C and I'd like to input the formula in column O.
Any help would be great - thank you.
I currently have a data validation list, with a VBA that allows me to select multiple items in one cell. The items selected in the list are the headers of a table. I'd like the headers to be the criteria range used when referencing the cell with my data validation list, to sum the data below that match the list criteria.
The issue I keep running into, is the multiple items in my list are not being read independent of one another.
My data list is in column C and I'd like to input the formula in column O.
Any help would be great - thank you.