Question Locked
Excel - Combine 2 Dynamic Ranges
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have 2 different ranges that are from different columns. Does anyone know how to make 1 range that contains everything from those 2 ranges? I am trying to use data list validation on some cells where you can choose from either of those 2 ranges.
Thanks