if cell contains text, then copy/paste on the next one

[extremis]

Hi,

I have multiples checkboxes on sheet 2.

On sheet 1, i want that the checkboxes (all in coloumn B) when checked copy the text in their respective row (in A) in sheet 1. This is easy....

What I want to do is that if in sheet 1. Check my file to see what i try to acheive!!!

So basicly, when there is text on Summary, and the checkbox is checked in the sheet input. I want that it copy to the next cell..


.test.xlsm

[Mumps1]

Try the attached file. I have eliminated the check boxes and replaced them with a drop-down list. This just made it easier to program. Just click "yes" and the data will be copied to your Summary sheet.

[extremis]

Hi,

good thinking but!! I have to see the Yes / No (need to appear). I also need to be able to reproduce it on another sheet. ;/

[extremis]

The good thing is that when it's true (yes) The line is copied to the other sheet :D...that worked well!! ..but unfortunatly, i really need the checkbox ;/

[Mumps1]

Try:

Please Login or Register  to view this content.

[extremis]

it worked well, but how can I would like to erase the copied cell if the checkboxes is uncheck...would it be possible?

[Mumps1]

Try:

Please Login or Register  to view this content.

[extremis]

it doesnt dissapeared when unchecked ....

[Mumps1]

Try the attached file. Make your changes in the "input" sheet and click the 'Process Data' button

[extremis]

Solved.

I modify the code a bit to make it work to my need.


thanks

[Mumps1]

I'm glad it worked out for you.