deadlyliquidx
New Member
- Joined
- Feb 6, 2015
- Messages
- 27
Hi There!
I need a VBA that will log any changes made on certain columns on a separate sheet automatically.
For arguments sake lets say the columns that will have changes made is Columns A and C in a sheet called "Data".
The Log Sheet will be a sheet named "log".
I want as much information as possible on the change
User Name, Date of change, previous value, New Value, everything possible to get.
I am trying to keep track of what changes are made and whom from what department made it.
I found several variations of my questions but nothing specific to changes to particular columns.
Thanks ALOT!!!
I need a VBA that will log any changes made on certain columns on a separate sheet automatically.
For arguments sake lets say the columns that will have changes made is Columns A and C in a sheet called "Data".
The Log Sheet will be a sheet named "log".
I want as much information as possible on the change
User Name, Date of change, previous value, New Value, everything possible to get.
I am trying to keep track of what changes are made and whom from what department made it.
I found several variations of my questions but nothing specific to changes to particular columns.
Thanks ALOT!!!