VBA if cell value = “no” then copy certains cells from same row to next blank row

I have a worksheet called 1B, i have a form that starts at A8, i would like that if the cell M8 contains the word "NO" then automatically copy A8 to B8 to next empty row and also copies the cells from C29 to O29 next to it, so on next empty row (row #30) will be a copy of A8 to B8 and C29 to O29. then for example, i have the same form but on row 10 so starts at A10 so also if M10 contains the word "no" then automatically copy A10 to B10 to next empty row and also copies the cells from C29 to O29 next to it, so on next empty row (row #31) will be a copy of A10 to B10 and C29 to O29. etc. thanks so much!

Alansidman, first of all thanks for your reply, well i have uploaded again the work sheet, so what i need is for example i have data on the row 8, then if at M8 i write "no",then automatically copy A8 B8 and C8 to row 30 (to A30,B30,C30) then copy all starting from c29 and ending at o29 to c30 to o30

I hope my reply comes across as constructive, but I see what you're after and I don't advise it much.

Reason being is you'll have to create a macro that is constantly running, checking each cell as you entering data. This can be quite stressful on your computer and may likely slow down excel altogether.

Could I suggest maybe a button to activate the macro when required?

hi, yeah a button would be fine, then i would like for example if i also write "no" on m10 it does the same but with the row 10, and it goes to the next empty row,then copies a10,b10,c10, in this case to row 31 (a31,b31,c31) then copy all starting from c29 and ending at o29 to c31 to o31, and so, thanks!

is it possible? thank you for your replies!