program not extracting required info

If anyone can help I have received a program from someone that is not working correctly.Unfortunately they are not currently available to correct this.and the program is way above my knowledge.
As briefly as possible I will go through it. From the main tab select analyse, as it stands this will select the file in sistrace2, select check/uncheck all then analyse selected users and then select all users. This will produce an interactive sheet then click export, this will produce a summary spreadsheet in the user actions tab.
The problem is although the numbers in the spreadsheet appear to be correct for each user what it is not doing is selecting the "shift" correctly for each user. It should extract this info from lines 76-256 in the main tab. We should be able to manually inport into this area,
What the spreadsheet should currently be producing is all users as "AM" bar one as "NIGHTS".and no "UNDEFINED"
I hope the code below is where the problem is but my knowledge is very limited and so I have no faith it is and so I have put an unprotected version of the full macro in the spreadsheet in the zip.file attached.
If anyone can find the solution it would be very much appreciated if you could post the code altered a) to increase my knowledge and b) so I can tell the creator what has changed when they are available again

Please Login or Register  to view this content.