tick box with formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am designing a sales pipeline which is easier and faster to complete. I am
utilising checkbox controls and this is working ok. My question is: Am I able
to have the contents of a cell copied into another cell on a new sheet
(within the same workbook) when a tick box is activated?
 
If you have the checkbox linked to a cell you can do something like this:

When the checkbox is checked the linked cell will evaluate to either TRUE
(checked) or FALSE (not checked)

Linked cell is Sheet1 A1

=IF(Sheet1!A1,Sheet1!B1,"")

Biff

"Excel_Can_drive_me_Nuts"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add contents of two cells when a tick box is ticked 2
Using formulas to count tick boxes or radio buttons 5
SUMIF, 3D FORMULA, EXCEL FORMULA HELP 1
Check Box Formulae 5
counting ticked check boxes 1
Adding sums from different worksheets 2
Filter query with checkboxes 0
Tick Boxes 3

Back
Top