How do I get a cell to auto fill if a check box on a different sheet has been selected?

[Wulf]

Sheet 1 = "COS". About 40% of the data on this sheet will transfer to the next sheet. How do I get a cell on the sheet 2 to auto fill if a check box on a sheet 1 has been selected?

Thanks!

 

[Gerald Higgins]

When you say "...if a check box on [a] sheet 1 has been selected" do you mean if the check box has been ticked ?

If yes, then it is fairly straightforward to use a formula that refers to the cell link for the check box.

For example, let's say the check box uses cell A1 as its cell link.

=if(A1=TRUE,"TEXT","")

This will show the word "TEXT" if the check box has been ticked, and will be blank if the check box is unticked.

 

[Wulf]

When you say "...if a check box on [a] sheet 1 has been selected" do you mean if the check box has been ticked ?

If yes, then it is fairly straightforward to use a formula that refers to the cell link for the check box.

For example, let's say the check box uses cell A1 as its cell link.

=if(A1=TRUE,"TEXT","")

This will show the word "TEXT" if the check box has been ticked, and will be blank if the check box is unticked.

Trying to figure out how to make this work....where do I plug this formula in?

 

[Wulf]

Disregard, I figured it out!

 

[areopagite]

Can you teach me how you did this?thanks