Day: February 7, 2012

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...