jmrobinso2
New Member
- Joined
- Mar 15, 2018
- Messages
- 1
I have =CUBEVALUE() functions referencing twenty Lists created with Data Validation (Bolded below).
=CUBEVALUE("ThisWorkbookDataModel",$B$2,$B$3,$B$4,$B$5,$B$6,$B$7,$E$2,$E$3,$E$4,$E$5,$H$2,$H$3,$H$4,$K$2,$K$3,$K$4,$K$5,$N$2,$N$3,$H$7,$A$1,$A12,B$11)
The limitation is that only one value per list can be selected.
Is there a way to get the =CUBEVALUE formula to reference a checkbox (List Box (Active X)) so that multiple values are referenced?
Example:
Current: $B$2 List - Select - Waldorf Astoria. Returns total Revenue for Waldorf Astoria
Desired: $B$2 Checkbox - Select - Waldorf Astoria, The Watergate Hotel, Beverly Hills Hilton. Returns sum total Revenue for those three hotels.
Thank you!
=CUBEVALUE("ThisWorkbookDataModel",$B$2,$B$3,$B$4,$B$5,$B$6,$B$7,$E$2,$E$3,$E$4,$E$5,$H$2,$H$3,$H$4,$K$2,$K$3,$K$4,$K$5,$N$2,$N$3,$H$7,$A$1,$A12,B$11)
The limitation is that only one value per list can be selected.
Is there a way to get the =CUBEVALUE formula to reference a checkbox (List Box (Active X)) so that multiple values are referenced?
Example:
Current: $B$2 List - Select - Waldorf Astoria. Returns total Revenue for Waldorf Astoria
Desired: $B$2 Checkbox - Select - Waldorf Astoria, The Watergate Hotel, Beverly Hills Hilton. Returns sum total Revenue for those three hotels.
Thank you!
