Copy Cell Value to Another Sheet if Checkbox is Checked

[Jennable]

Hello! I am hoping one of you Excel geniuses might be able to help me with this! I have a spreadsheet with a number of columns representing different areas of business (Columns B, D, F, H, J, L & N). Each topic is separated by a column where each row contains ActiveX checkboxes (Columns C, E, G, I, K, & M). What I am wanting to do is write the code so that if a checkbox is checked, the contents of the cell adjacent to it will be copied to a new sheet (creating a list of the most pertinent action items). For example, IF C9 is checked, B9 is copied to the new sheet. I know how to code this simply using the IF function however the problem I am having is that it's not a 1:1 transfer-- ie I want it to function so if any of the checkboxes are checked, that cell is copied to the new sheet one after the other. I'm hoping this makes sense and you can help! Thank you in advance.

 

[Skyybot]

@Micron, yes. Although, if I want to work with data only if the Checkbox is checked, then the True/False state of the Checkbox does have value. I just hide the Column so that state is not visible. Technically, you could put the state of the Checkbox in the Cell that it's "covering" and format text to White. Either way.