Scripting dictionary help

Hi

I attach my code and also the workbook (with the code in it along with the test data under the DATA tab, tab 1 is the macro and sheet 2 is where the macro puts the results to. I have added an expected result tab to show what I need the code to do )

The code runs for one line only- I am trying to adapt this code from another piece of work and as you can see I am a novice
Any help would be grately appreciated !

Please Login or Register  to view this content.

Hi Norie - thanks alot that is exactly what I am after. But just one thing - why is it not bringing in the last row under the expected results for Jane - the very last row (row 7) - when I run the code it excludes this row ?

Thanks
Leanne

Hi Norie

I initially thought it was only the one row - but when I use the code on a larger volumn a lot of the data is missing ?
I reattach a larger sample and have the updated code saved in. I have also updated the expected results to help.

Basically for those under the task responsibility who have task "Payroll Final Preparation" then I want that processor, the client name and due date taken from column k in the Data sheet and put in column c in sheet 2.

Same for task description "Payroll Final Review and Delivery" - I want the processor, the client name and due date from col k in the Data sheet and put in column D in sheet 2.

Thanks
Leanne

The code you modified was looking at the wrong columns, Try this:-
Results sheet2

Please Login or Register  to view this content.

Regards Mick

Hi Mick

You can see this is your work from previous that I have tried to adapt to similar piece of work. When I run your code above it gives me a run time error 9.

Thanks
Leanne

You seem to have 2 different files, my code was working on the smaller one (19 rows of data), My code was working on that. I imagine you want it to work on the other file, with 49 rows of data, I'll have a look !!!!!

Try this on the bigger file.!!

Please Login or Register  to view this content.

Regards Mick

Hi Mick

Yes the smaller file works but I have also found this in past. Seems to captures all of the errors at the one time with a larger volume of data rather than me to continue to pester people over and over again.

Thanks for your help
Leanne