Cell Text Transfer with tick box

Occasional Visitor



I am trying to set up a formula that will a allow a user to click on a cell next to a cell with text in it that will then transfer the text to a sperate sheet when chosen, is this possible? 

1 Reply

@Danlach1220  Yes, this should be possible. You can ask people to put an x in the box beside the text and then write an =IF( ) formula that will copy the text in the cell beside the x to the separate sheet as long as the x is present. If the x is absent or if they type anything else in the box besides an x then it will leave the cell in the other sheet blank. 


See attached for example