Move Changed Rows to another sheet

[JGOpsMgr]

Good morning, First let me say I am not a code writer. I am a simple operations manager and excel enthusiast. I use excel to track multiple functions within my operation. I have a sheet that is used by only one person. The data is in columns A-R. I would like to copy the entire row if something was changed in column K and paste it to another sheet. I am currently using another VBA I got online but it is cumbersome and takes up a lot of space to log every cell changed. I dont need to know who changed it nor do I need to know every cell that is changed. I simply want to copy and paste it if the one cell in column K with the header "Status" is changed. Below is the code I am using currently.

 

[JGOpsMgr]

If this is what will be useful we can add in the column headers later.

Loe it! Very easy to manage. Thank you so much for your help!

 

[JGOpsMgr]

Just change "Differences" in the code to "Audit".

Do you want the code to clear all the old info in the Audit sheet before copying the new info?

Thank you so much for your help but I think I will go with the other option. just because I got it first and it works for me so thanks again

 

[HighAndWilder]

Loe it! Very easy to manage. Thank you so much for your help!

Do you want the column headers for the summary?

 

[JGOpsMgr]

Do you want the column headers for the summary?

Just one issue, The code works great and does exactly what i want it to except, it changes the time stamp formula in the master sheet to a date but with a time of 12:00 am and the formula disappears. How do I get it to keep the formula and correct time format which is m/d/yyyy h:mm AM/PM

 

[HighAndWilder]

Just one issue, The code works great and does exactly what i want it to except, it changes the time stamp formula in the master sheet to a date but with a time of 12:00 am and the formula disappears. How do I get it to keep the formula and correct time format which is m/d/yyyy h:mm AM/PM

Can you apply this custom format in the appropriate column on the sheet that has the filtered data?

 

[JGOpsMgr]

The column is already formatted as above. I keep getting an "inconsistent Calculated Column Formula" error