Copy cells from a row in one sheet to next row in second sheet based on check box

Greetings. I assume I need to create a formula or macro for this. But it is new territory for me....

I have searched and been unable to find what I need so that I can take the first 5 cells of my "prospects" sheet if the check box is ticked and copy them to the first five cells in the next free row in my "in progress" sheet. See attached. Is it possible for this novice to get some instruction? Thanks so much!

Ok so the Corporate Partner, Orignal Owner, Number, Financial Commitment, Company contact, and follow up meeting should be copied?

Thank you for your quick reply! Everything but the follow up meeting (just the first five) need to be copied from prospect to in progress.

try this

Please Login or Register  to view this content.

This looks great. So sorry to have to ask this....to where do I copy this? Is it a Macro?

Here is the work book with it in there already. For future reference you would press ALT + F11 and right click the white space on the left. Then insert a new module and paste the code in there. To runt he macro hit ALT + F8 and select the macro you wish to run.

Way cool! I so appreciate your guidance here. I will be able to utilize this as I create similar types of workbooks. Thank you again for your help!

I just thought of this though, if you run it twice with it checked it will copy it twice. There are a few ways to avoid this, we can delete the line as we copy it, or if you need the list intact i can have it check if it already exists.

That would be great. Do you mind doing that? Thank you!

It occurs to me that I didn't specify which option is best for me. I do need the list intact. So if you can have it check if it already exists, that would be terrific.

Here you go, this will prevent duplicates now

Thank you. I so appreciate this. What it seems to do is un-check the check box once I run the macro. So if I want to keep record of it having been moved on the prospects sheet, I could just create another check box that is not linked to the macro. Correct?

No i told it to do it. Press ALT + F11 and go to Module1 then delete this line:

Please Login or Register  to view this content.

Works like a charm!
Now all I need to do is copy this macro into the real worksheet. Thanks for walking me through this process. What a huge help this is!