Hi
I have uploaded a test macro workbook. 1st tab is the macro to run the data in sheet 2 and sheet 3 is the output data.
I am almost there with it, the problem is that one of the dates is appearing as blank.
So what am I doing:
In the column "P11D data rec'd" I am looking up the specific task in sheet 2 called "P11D data received" I am pulling in the date from column M
In the column "P11D Data due back" I am looking up the specific task in sheet 2 called "P11Ds prepared and submitted to client" I am pulling in the date again from column M.
Finally In the column "Completed" I want the date from sheet 2 under column O called "Completed Date" for the specific task in sheet 2 called "Final P11Ds submitted to HMRC"
For some reason and for the one with the completed date the "P11D data received" is not pulling the date in. Even when I remove the completed date to test its still blank - what am I doing wrong ?
Thanks in advance for any help
Leanne
Bookmarks