-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Need help copying several cells to another sheet, based on the condition of a check box
- Thread starter Dking911
- Start date
billgyrotech
Banned
- Joined
- Apr 24, 2014
- Messages
- 71
Hello and welcome!
In order to utilize the checkbox you have to link it to the cell K3 and I am assuming that it is from Sheet1 in my code. Then you just have to make a formula when that checkbox is true.
Put this code in Citations!B3 and then copy that to the other cells. I hope this helps you understand how to link the checkbox to populate the cells.
In order to utilize the checkbox you have to link it to the cell K3 and I am assuming that it is from Sheet1 in my code. Then you just have to make a formula when that checkbox is true.
Code:
=IF(Sheet1!$K$3,Complaints!B3,"")Put this code in Citations!B3 and then copy that to the other cells. I hope this helps you understand how to link the checkbox to populate the cells.
Last edited:
Upvote
0
Similar threads
- Solved
- Solved
