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