How do I create a formula?

[Tammy 2 Do]

Hi,

I need a formula or solution to capture information on a separate worksheet
within my workbook. If it is possible, I would like to have a page that auto
populates
only the questions on a previous page that are checked in the forms checkbox
in the column next to that question. This is hard to explain but I think
there is
a solution for it. Example worksheet 1 - column a has the question
column b includes boxes from the forms field that are checked if they are
items
the be reviewed by the team. I would like all of the questions that are
checked
to auto populate on a separate worksheet. Is this possible?

 

[Dave Peterson]

How about an alternative (easier, but different)?

Assign a linked cell to each checkbox (say column C of the same row).

Then apply Data|filter|autofilter to that column.

Filter to show only the True's.

You could use a new column A and not include that in the print range--or just
hide that column if it's too ugly.