VBA to copy row (or selected cells) from one sheet to another

Hi folks,

Hopefully someone can help me please?

I've created a workbook with different tabs - including Risk Register and Checkpoint. What I'm trying to do is when the user completes the Risk Register and inputs a Y to "Send to checkpoint" the row copies over into the Checkpoint. I did have it set with a formula but it meant if people had a Y followed by N then there would be empty rows on the Checkpoint, so I think VBA is the only way to copy it over...I just can't figure it out. Does anyone know how it do it please?

I've tried the following but it's getting a runtime.

Please Login or Register  to view this content.

Example attached.

Thanks very much

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Use a Worksheet Change Event and place it in the Risk WS

Please Login or Register  to view this content.

Let me address the issue of Runtime error:

May be the issue is because you use "printing" quotation marks?

like:

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

Check the attached file.

PS. Note that Risks have to be active sheet before you start the code. otherwise results will be unpredictible.

Here's your file with my code embedded.