Only Show Checked Items
 

I have a data input sheet that allows a user to select options with a check
box. This information is then shown with a price after the box is checked on
a new quote sheet. This also displays non-checked information but without a
price. I'd like the sheet to only show the description & the price of checked
items. Another user here uses a Mac so including any programming is out of
the question. Any ideas?

Only Show Checked Items
 

You can blank the information out by using a formula or conditional formatting.

With a formula, if sheet1 has the check boxes and sheet2 the pricing, and
assuming the 1st checkbox is tied to say, a1 and the description is in say,
b1 on both sheets:
put this in B1 on sheet 2
=if(sheet1!a1=true,b1,"")

With conditional formatting you can use "=sheet1!a1=false" without the
quotes in sheet2 b1, just make the font color to be the same as the cell
background. (Usually white.)

Squeaky

"Jesss" wrote:

I have a data input sheet that allows a user to select options with a check
box. This information is then shown with a price after the box is checked on
a new quote sheet. This also displays non-checked information but without a
price. I'd like the sheet to only show the description & the price of checked
items. Another user here uses a Mac so including any programming is out of
the question. Any ideas?