Skip to content
Parth Shah

Month: October 2014

Excel

Excel Drop Down List with Data Validation and Auto Complete

by : Parth ShahOctober 20, 20142 Comments on 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 […]