Hi,
I have a range of cells on sheet1 L11:CO50 that contain formulas, what I would like to have happen is if the user overwrites the formula with a new value that a macro runs that will copy the value from the target row in column F and the also the difference from the original formula value and the new value and enter this data onto sheet20 in the next unused row.
I.E.
Cell M22 has an original formula value of 100 and cell F22 contains FGH012 then the user changes the value in cell M22 to 12,5 the macro would then copy the text from cell F22 and also the difference from the original value in cell M22 (125-100)=25 this would then be entered in the first unused row on sheet20 after row 5 based on column F so that the result on sheet20 would be cell F6 contains FGH012 and cell M22 contains 25
Any help would be much appreciated.
Regards,
I have a range of cells on sheet1 L11:CO50 that contain formulas, what I would like to have happen is if the user overwrites the formula with a new value that a macro runs that will copy the value from the target row in column F and the also the difference from the original formula value and the new value and enter this data onto sheet20 in the next unused row.
I.E.
Cell M22 has an original formula value of 100 and cell F22 contains FGH012 then the user changes the value in cell M22 to 12,5 the macro would then copy the text from cell F22 and also the difference from the original value in cell M22 (125-100)=25 this would then be entered in the first unused row on sheet20 after row 5 based on column F so that the result on sheet20 would be cell F6 contains FGH012 and cell M22 contains 25
Any help would be much appreciated.
Regards,