When you are creating a drop-down list, you will use ‘Data Validation’ to restrict the type of date or values which users enter into cells. To calculate the maximum allowed value in a cell based on a value elsewhere in the workbook, you probably will also use data validation. If
Continue readingMore About Data Validation Excel Drop Down List