Cant get data to populate in VBA code from array & scripting dictionary

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

Can anyone help? Thanks

Originally Posted by briguin

I don't know the answer, I've offered up the things I would look at. I did briefly read the code in the spreadsheet but did not do a full analysis.

I think an example of what you expect to happen would be very helpful.

In your example, I see you are referencing the column = to "P11D Data due back". I don't see that string in the columns.
You referenced the column multiple times with examples of strings you were looking for.
"P11D data rec'd" --I saw in column J
"P11D Data due back" - I did not see anywhere in your data
"Completed" - In column L, which was different then column J. However, your description makes me think that you think they are in the same column.

Hi, I appreciate you looking at the code. The p11d data due back is the p11ds prepared and submitted to client task.
The code works fine apart from the one blank date in column 4 which won't populate. For the two tasks "p11ds prepared and submitted to client" and "p11d data rec'd" the code is pulling in the due dates from column m in sheet 2 being the data and I have it being populated in sheet 3. But for some reason for one client it's not pulling in the due date - see sheet 3 for the output.

Can anyone help - sheet one is the code, sheet 2 is the data from where I am pulling the processor, client name and due dates from onto set 3. Sheet 3 is the output and all looks good apart from the blank cell under data due in

Many thanks
Leanne