Hello,
I'm fairly new to programming in Excel but i have some experience in programming in C. I have used Excel for basic ploting, functions, etc...
My question is as follows, I have a table of which certain numbers are updated periodically similar to the one below. I would like to capture the date when the data was updated as well as what the number was before the what it was changed to and what the number is currently. I have no experience in VBA so i have no clue where to start.
I have multiple tables in a sheet but im sure once i get the pattern i will be able to apply the code to the other tables.
I also forgot to mention that i would like to have this changelog within the same workbook but different sheet. Thank in advance for your help.
I'm fairly new to programming in Excel but i have some experience in programming in C. I have used Excel for basic ploting, functions, etc...
My question is as follows, I have a table of which certain numbers are updated periodically similar to the one below. I would like to capture the date when the data was updated as well as what the number was before the what it was changed to and what the number is currently. I have no experience in VBA so i have no clue where to start.
I have multiple tables in a sheet but im sure once i get the pattern i will be able to apply the code to the other tables.
I also forgot to mention that i would like to have this changelog within the same workbook but different sheet. Thank in advance for your help.
Last edited: