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

1 reply

This discussion is closed to new replies.