Hi,
i want to detect changes from Sourcedata worksheet data and reproduce them in table.
Screenshot_6.png
Numbers are values and Fields are column names in table (so table has one row only).
Screenshot_7.png
and i have to add mechanism to Check if new fields to the table:
1. Were added (example, Field4 with value 4 was added in Sourcedata worksheet).
2. deleted (Field2 and value 2 was deleted from worksheet Sourcedata)
3. Any value in Fields 1,2 and 3 were changed.
Screenshot_8.png
I was thinking to use dictionary but i am noob with this object ( i know what is this and how to use) but i can not imagine how can i implement in this specific case.
Thanks
Bookmarks