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?
Bookmarks