How to save Changed value of range of cell along with the date and time in another sheet

It is easy enough to do, but you nee to have an EVENT MACRO which is triggered when you change values in the nominated column.

Best if you attach a sample copy of your workbook (follow Ben's instructions in Post #2) and we can show you how.

Regards,

David

Hello David

Thanks for helping
I have attached a demo file.
I hope this will help you understand my problem.

thanks again

NOTHING ATTACHED

In original post I have edited and attached.

Can't look at it today - probably tomorrow!

DAC

Here is your model.

eraditya - demo problem.xlsm

If you change any value in Column C, the Change Event Macro will fire, and add the new value to the corresponding row on Sheet 2.

If you add a new Ref No to sheet 1, and it is not found on sheet 2, you will get a "Record not found" message.

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

If several people have responded, when you reply please make it clear WHO you are responding
to by mentioning their name.