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?
