Excel Drop Down List with Data Validation and Auto Complete
Have you ever ran into a scenario why you want to limit the possible values a cell can have but at the same time the range of values that cell can take is changing dynamically? Scenario: You have a dedicated sheet for entering data into your Excel Workbook. One of the fields is best represented as a […]