Create Data Validation List from Excel Table as Source

A common complaint of many Excel users is that they can’t directly use Excel table’s structured references in data validation to create drop-down lists. If you try, Excel would give you an ugly pop-up and refuse to play along. But what if you still want to (somehow) use Excel table as the source in data ... Read more

from Online Excel Tips – Blog – Trump Excel https://ift.tt/WCLtPew