Block certain cells in condition met in cell A

[Clairexcel]

Hi there,
trying to figure out step by step how to build macros and learn more.
Now given that my other code was a mess, I figured I would simplify things. So let the formulas in the cells of my worksheet, but I would like a vba to perfrom the following:
1. My worksheet goes from A to T5000
2. If a user enters YES in cell A of a row, then I would like to block cells K, L, P, Q and T on that row, so that users can not enter anything in those cells.
3. Otherwise, if they they enter "no" in cell A, then the K, L, , Q should be unblocked in that row and they should be able to enter numbers. Cells P and T should always remain blocked though.
4. Also if cell A contains "no", I would like vba to automatically copy C to H range from the row above.
Is there any way I can record macros and then create a event macro with conditions if so then perform macro1, else perform marcro2"" ? How can I create such macros?
Do I have to create event? If so, can you please help me as in how to do it?
Thank you so very much.

 

[Clairexcel]

That code should copy cells C:H
Do you get any error messages & are there values in E:H?

No, no errors at all...

 

[Fluff]

And are there any values in cols E:H?

 

[Clairexcel]

And are there any values in cols E:H?

yes there are, i typed some in the row above to see if they copy

 

[Fluff]

Are there any merged cells?

 

[Clairexcel]

Are there any merged cells?

@Fluff sorry for replying in delay yesterday night I was off wifi. No, there aren't any cell merged in this file. And After I opened it today the vba code still works but only in the first row where I input yes. It only blocks the cell K, L etc for the first yes, afterwards, in the other rows it doesn't...I am sure it is smth I did wrong, but I can not figure out what. Thank you for any further help you are willing to give me

 

[Fluff]

Do you have any other event code in the workbook?

 

[Clairexcel]

Yes, that was it... and maybe my file was having some issues on itself after so many changes and trials. Infact I created a new file, and it is working perfectly! Both locking corresponding cells in the row and copying C:H from row above if A contains no....
I can not THANK YOU enough. Thank you so very much indeed, I hope to be able to repay you with a code sooner or later!

 

[Fluff]

Glad it's working & thanks for the feedback.