I trying to figure out how to automatically copy the values and formatting from cells range (E72:U95) and paste the values and formatting only, not the formulas on cells range (E45:U68) every time value on cell (Y12) changes to any value. I use this to save last entered values on E72:U95 after they are deleted.
Any assistance is greatly appreciated, thanks in advance!!
I tried this code i found on the web but is not working properly after the first cell change and when it does trigger miss some values and formatting