Example 1 - Allow user to select VarNum to display Variable Info, Average, Min and Max. 

1. Use Dashboard>Button in Spread Design.
2. Click Misc and choose Pick VarNum.
3. Enter the button text
4. Click OK
5. Enter a default varnum in C3 (the cell that will be set when a Varnum is selected).  The Pick Varnum will place the text in the cell to the right when it is used in a dashboard.  Hint:  You can merge B3 and C3 if you want to hide the text that the pick returns and you can still refer to C3 to see the data.
6. Enter the following formulas:
1. C5: =VINFO($C$2,"VarDisp")
2. C6: =VINFO($C$2,"Units")
3. C7: =GAVG($C$2,1,"R")
4. C8: =GMIN($C$2,1,"R")
5. C9: =GMAX($C$2,1,"R")

Example 2: Allow user to select Multiple VarNums to display Variable Info, Average, Min and Max. 

1. Use Dashboard>Button in Spread Design.
2. Click Misc and choose Pick VarNums.
3. Enter the button text
4. Click OK.
5. Enter a comma separated list of VarNums in C3 to use as the default.  The Pick Varnums will place a comma separated list in the cell to the right when it is used in a dashboard.  Hint:  You can merge B2 and C2 if you want to hide the text that the pick returns and you can still refer to C32 to see the data.
6. To display each VarNum Individually use the Split function.
1. C4 =Split(C3,",",1)
2. D4 =Split(C3,",",2)
3. E4 =Split(C3,",",3)
4. ...
7. Enter the following formulas:
1. C5: =VINFO($C$2,"VarDisp")
2. C6: =VINFO($C$2,"Units")
3. C7: =GAVG($C$2,1,"R")
4. C8: =GMIN($C$2,1,"R")
5. C9: =GMAX($C$2,1,"R")
6. Highlight C5:C9, F5 Copy Special, Highlight D5:J5 and F6 Paste Special.