Check Box Items Displayed On A Differnt Sheet

[strams]

Hello Everyone,

Hopefully this is a simple question that my lack of Excel knowledge is stumping me on and one of you might know...

I have a series of checkboxes, we'll say checkbox 1-5. These are all listed on a sheet called products.

If for example you select check boxes 1,3 and 5 I need those to then be listed in a column in that order on another sheet called purchased.

If I went back and then uncheck 3 and check 4 then purchased would be updated.

I understand that if you take a cell and name it P1 for instance..and then on another sheet enter =p1 in a cell that they will update and share data, but I dont know how to pull from a check box..nor do I know how to assign a row of cells to accept multiple and changing information from those checkboxes.

Hopefull i explained that well enough. Any help would be appreciated...thanks in advance.

 

[Ron Morris]

I am assuming you are using a checkbox from the forms toolbar.

You can always create a column to hold the selection of the check box since check boxes always return either TRUE or FALSE.

Right click on the Checkbox and then click on "Format References"

At cell link, enter the cell you want the result of the checkbox to appear.
Repeat this step for all your checkboxes.

Hide the column.

On your purchased page, write a formula referring to the TRUE OR FALSE CELL, I am using A1 for the sake of an example.

=IF(A1=TRUE,"Apple","")

This would create your list but leave blank spaces whenever something isn't purchased.

Ron