Multiple-Validations (connected to each other)
Here is the free file for a special request by a client He wanted to have multiple cells having Data – Validation to same list...
WorksheetName and WorksheetsNo UDFs
Once you open the sheet and enable macros, you can use function: =WorksheetsNo() To get total number of sheets in that workbook And use function:...
Dynamic selection list
Using Index and CountA Formulas, Names and Forms > ListBox to have a list with connected formulas Can also be used as form to read...
Validation based on another Validation
Creating a Data Validation based on another Data Validation Meaning that when you select from a drop down from the first the second will be...