Apologies in advance as I think there are some threads covering similar topics, but I have been unable to get the vba in them to work as needed, as I'm pretty new to it.
I am creating a risk register table (in a worksheet called Risk Register) with values added and updated from an input macro, which I have managed so far. However the values in the table are simply overridden. So I would like to create a second table in a worksheet called tracker that tracks the history of one column in the table (the risk rating, column H)based on the risk ids entered in column C in the table so I can see how the risk has changed overtime. The new table would show the risk ids, the current and all previous ratings for them and the date on which they were changed.
Also how would I input this macro
Any help gratefully received
I am creating a risk register table (in a worksheet called Risk Register) with values added and updated from an input macro, which I have managed so far. However the values in the table are simply overridden. So I would like to create a second table in a worksheet called tracker that tracks the history of one column in the table (the risk rating, column H)based on the risk ids entered in column C in the table so I can see how the risk has changed overtime. The new table would show the risk ids, the current and all previous ratings for them and the date on which they were changed.
Also how would I input this macro
Any help gratefully received
