Hi,
I hope I am in the forum for this query. I have a work book that I currently use as a risk register within work. The way I have it set up at the moment is. each division has its own individual sheet and hten using power query I have appended each of the sheets to create a master data sheet. This sheet keeps everything up to date and current with the push of the refresh button.
However this is where things get a little tricky and I am unsure if this is even possible. I have been asked to record all changes made to the register. I am hopoing that I can create an additional sheet that wil auto populate any changes made to the master data sheet. If the description changes, mitigations or score.The last version of that entire row will copy to the changes sheet and the master data sheet will be up to date and current. I have attached a sample workbook owith the type of data I am recording.
Hoping to find a solution to this. Thanks in advance for any help
Office Suite: Office 365
Bookmarks