I currently have a master sheet that I am compiling all audit results in, however this is becoming clumsy to use and it exposes some findings between regions that i may not wish to do.
I want to give out individual worksheets to each region and when they update their copy it automatically updates the master. If something is changed in the child then just the changed date should be updated in the master, if something new is added then this record is added in full.
Each row in each sheet has a unique reference number (Unique between sheets also) so that I can identify individual rows.
I am not sure what is the most appropriate method, I have seen some posts looking to achieve this or part of, however I cannot get my head around how I apply it to my requirements.
Any help would be greatly appreciated.
I have attached examples of the master and child workbooks.
Thanks in advance.
Bookmarks