Hi, I've been searching online and doing a lot of trial and error but I haven't been able to make it word. If someone could kindly help me, I'll apreciate very much.
On Worksheet "Original" there's Table1 with columns [Name] [Number] [Info] [Status]. There are no rows with the same [Name], as Table1 works as a Contact List.
On Worksheet "History" there's Table2 with columns [Name] [Number] [Date]. There can be duplicates for [Name] as Table2 works as a Log.
What I'm trying to do is that everytime I chance the value of [Status] to "Called", the values of [Name] and [Number] from that specific row in Table1 will be copied to a new row in Table2, and in that new row, under [Date], will be added today's date.
If you would like I can add some of the code Ive been trying without success.
Thanks in advance!