If your list and dropdown are on different pages, you’ll need to know this trick to make the dropdown dynamic.
The post How to populate a dropdown with data from another sheet in Excel appeared first on TechRepublic.
Support the originator by clicking the read the rest link below.