I am building a check list that will identify what has been created during the course of the day and then when the item is authorised show the item as completed.
the procedure will be:
When the original item is created it will open a workbook [called Sign Off Log] and in the sheet named 'Log' enter the details from the active workbook: It will find next blank row in Sign Off Log Wb and enter current Date [Column A], Reference from C5 in Active Workbook to [Column B] and Pay Date from Active Workbook to [Column C] and then close the workbook.
When the item that was created previously is being authorised, it will open the workbook [called Sign Off Log], find the respective item in the sheet called 'Log' [i.e. look up the reference in cell C5 and find in Sign off Log then copy 'P and Q' from file and paste into 'D and E' in the 'Sign Off Log' workbook. Then close the 'Sign Off Log' workbook.
That sounds complicated but I have attached a file that should make it a little clearer, The file I have attached represents the ' Sign Off Log' The data that would populate this is from the original file that would contain the Macro.
So if I have the original file open and I am entering a new item it would open the Sign off Lofg and find the next blank cell then enter details into A,B and C.
If I am doing the authorising then I would open the sign off file, find the relevant item using the Reference from C5 and look this up in the sign off log and put data from P3 and Q3 in D & E highlighted orange in both files.
I hope this is clear enough.