Create a change History on seperate worksheet.

[todmac]

I have a worksheet that we use to track locations of unit numbers. Each unit has a drop down box that allows the user to select the location of that unit. Very simple workbook, gets opened locations updated, saved and closed.
I would like to put in some code so that every time anything is changed the before and after values, date and time of the change, and username of excel user to get stored in a seperate worksheet. So essesntially you can see who changed a value and when. Has anyone done this before and could share their thoughts?
One things to consider is that my workbook will be shared in the future.

Thanks in advance.
T

[JOHN H. DAVIS]

Maybe some sheet event code using these snippets for your destination sheet.

Please Login or Register  to view this content.

[todmac]

That didnt go over too well.
Is this just to insert the Data into the sheet ( finding end of information and setting values?).

I am trying to find a way to capture the targets value before the change event and after the change event.... any thoughts?

Thanks.