sswcharlie1
New Member
VBA code to 1)Log changes and 2)Highlight changes of changed cell(Color and comments)
Hi . I have to track changes to a file that I will be sending to my colleagues to revise. I tried to google and refer to youtube but I was not able to figure it out so I hope someone can help me revise or improve the code. 1)Log Sheet: now it is only showing the new value (changes). I want to...
chandoo.org
Hi
A very good post on above link re log of data.
I am in need something a lot more basic.
Have worksheet1 with tableA and worksheet2 with tableB .
tableA records data from userform (items in and items out), entries added and entries removed. Data from 1 to 50 rows varying.
tableB is to record any items in or out. Other items will remain in table.
more than 1 row could be changed each time from cut/paste action.
example single col., in rows of data
A
M
D
R
T
Then M & D removed. ( A second table will record this as item in)
Then
Z
99
43
added. ( another table will record the item out).
Log file ( ws2 tableB ) should then show changes
ColA ColB
Removed
M
D
Added
99
43
Z
Your comments will be appreciated.
Thanks
Charles Harris
NZ