evaluate and add points then update a sheet

Hi Guys,

I have an issue.

I have a sheet with a user ID and a list of courses.

The courses all have the same syntax. The course name, the level then 2 digits and then - Success if passed.

If i've been successful I have uploaded my two files for reference. First is a csv that the results download in.

The second has a macro, macro1. In this I'm trying to evaluate the course name.

If it has success in it I want it to add up the "points" for all the passed modules and then write this info onto sheet1.

Everything I have tried keeps failing. Can you have a look at the macro and find out why the case and look up isnt working?

I just don't understand what you are trying to do.

You would receive more response, if you upload a workbook with before/after out of the data(csv) you provided and the clear reason why.