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