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...
Sort list dynamically (functions)
Sorting a list automatically using formulas, with no need to press the sort command Also if the source table is changed, the destination table will...
Insert Blank rows into table using functions
Here you will see how to work with functions to insert a blank row every certain number of rows in a table using a blank...
Change Calculator – calculate change in multiple bills/coins
An Excel file that will determine what cash to return to the buyer (How much of each cash unit, or how many of Fifty dollars...
Progress bar in pure functions
This one is very similar to Tally chart, however, it is for another purpose. It is used to draw a progress bar, yes a progress...
Excel Dynamic Drop-Downs that grow with you
This will help you do a dynamic name to use on a drop down, a Form Listbox or Form Combobox. The screenshot almost says it...