VBA copy one cell to another

[Inuniform]

Hi everybody,

Essentially I need VBA for the IF function. If a cell in column K says "Malfunction" then the value within that row of column J has to be copied to column M. I hope that's enough information otherwise please let me know!

Sincerely,
Inuniform

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

@My aswer is this

I have made a button since I am working with a deadline and your initial code works perfectly! Thank you so much for your help and enjoy the holidays!!!

Inuniform