1. Bind labels of the selector (eg. B2:B5)
2. Set Insertion type and destination (eg. C2)
3. Set the selected item type on Dynamic on the behaviour tab of the selector
4. Bind the item to a cell (eg F2)
5. Bind source cell of Push button (eg. E2)
6. Bind destination cell of Push button (eg. F2, same as selected item of combo!)
7. Add formula in source cell push =if(F2=”x”,B2,”x”)
8. Add “x” value in destion cell F2
Comes in handy when you want to reset only certain parts of the dashboard and not resetting it to its initial state (as you do with the reset button).
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
No comments:
Post a Comment