'How to combine multiple ranges in drop down menu
I'm creating an expense tracker and would like different types of expenses to populate in 1 drop down menu (data validation).
Basically how do I combine multiple ranges (on a hidden sheet?) so that I can use that range in data validation. So far I'm using index but it returns 0 for the rows that are blank.
Or is there a better way?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|