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...
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
Then M & D removed. ( A second table will record this as item in)
added. ( another table will record the item out).
Log file ( ws2 tableB ) should then show changes
Your comments will be appreciated.