ahur
12-19-2016, 02:58 PM
Hello all, hope I could get some guidance from this forum here...
i'm working on a spreadsheet with full of data with check boxes and eventually turn into a new sheet populated with selected items.
To clarify, Worksheet 1 (called "Selector") shows all the data I will need and will have a check box on each item.
Once selected, the corresponding data (shown in the same row as checked box) will automatically populate to the other worksheet 2 (called "Quote") in a specified format only showing the checked items that customer wants.
If deselected, the contents of the items should be removed.
Another feature I would like to add is "Select/Deselect All" checkbox.
This is just a nice to have but not a requirement: I would also like to have only one "Selector" sheet but customer should be able to copy numerous "Quote" sheets to generate quotes automatically.
Thanks
i'm working on a spreadsheet with full of data with check boxes and eventually turn into a new sheet populated with selected items.
To clarify, Worksheet 1 (called "Selector") shows all the data I will need and will have a check box on each item.
Once selected, the corresponding data (shown in the same row as checked box) will automatically populate to the other worksheet 2 (called "Quote") in a specified format only showing the checked items that customer wants.
If deselected, the contents of the items should be removed.
Another feature I would like to add is "Select/Deselect All" checkbox.
This is just a nice to have but not a requirement: I would also like to have only one "Selector" sheet but customer should be able to copy numerous "Quote" sheets to generate quotes automatically.
Thanks