Conditionally insert a duplicate row

I have a table with hundreds of rows but here's a basic example:
__a___b_____c____
1 Color Dates Completed (headings)
2 red Date1 Yes
3 red Date2 No
4 blue Date3 Yes

I need a formula/macro that will create a duplicate row underneath a row if the cell in column c says "Yes". If it's "No" or blank then do nothing. The duplicate row should copy everything exept in column c.
Should look like this:
__a___b_____c___
1 Color Dates Completed (headings)
2 red Date1 Yes
3 red Date1
4 red Date2 No
5 blue Date3 Yes
6 blue Date3

Please help! Greatly appreciated

HI acohen12,

welcome to the forum.

Try using below code:-

Please Login or Register  to view this content.

Regards,
DILIPandey
<click on below * if this helps>

Okay .. use below code:-

Please Login or Register  to view this content.

Regards,
DILIPandey
<click on below * if this helps>

Thanks, so far so good!
I need one final adjustment to it now. Since I continually add more rows of data to my table, I am wondering if you can add a shortcut key like "ctrl+y", that will only use your macro on the active row.
Say here's a table:
__a___b_____c____
1 Color Dates Completed (headings)
2 red Date1 Yes
3 red Date1 No
4 red Date2 No
5 blue Date3 Yes (cell C5 is active)

I would like to press ctrl+y, then use your macro only on the active row, not row 2 also.

If you can do this, I would cherish you.

Okay.. see the attached file.

activerow checking.xlsm

select any row and press ctrl + y and this will insert a row down if "yes" is there in column C in select row

Regards,
DILIPandey
<click on below * if this helps>

Okay.. upload your workbook with this macro.



Regards,
DILIPandey
<click on below * if this helps>

Okay.. your data was converted as Table, now corrected... try using below file:-

change any value to "Yes" and press ctrl + y
macro.xlsm


Regards,
DILIPandey
<click on below * if this helps>

You are welcome

Please mark this thread as [SOLVED].. Thanks.


Regards,
DILIPandey
<click on below * if this helps>