User Defined Variables

1. This form will allow you to self define variable value and use in quantity column
2. when variable is changed the workbook will calculated again
3. then variable deleted, you will be forced to reselect the variables, so be cautious not to do this.

user defined variable form

File:UserDefinedVariable-sheet input.gif

software behaviour when changing quantity on sheet