I'm interested in auto generating named ranges for the sake of easy variable creation for formulas.
I generally use a tab called CONSTANTS while building calculators to help keep the data clean and traceable. Currently, every time I add a new constant, I have to:
- create a variable name ex. "Gravity" in A1
- in the adjacent cell, B2,type the value "9.8"
- Create named range "Gravity" that points to $B$1 containing "9.8"
What I would like to do is auto create a named range when a value is entered in column B and to name that range based on the adjacent cell.
Is this possible with formulas? I have not dealt with scripting yet and if it is scripted will it carry over with template if the user is not aware of how scripts work?