I need a macro that changes spread sheet 1 into sheet2 based on some figures
Col E - this shows form figure which are read from the right to the left
1st =5 points
So 127UP6-6614 (only count the first two figures and ignore the rest) 4=1point 1st= 5 points for a total of 9 points.
Where you can see a -(minus sign). Example 127UP6661-4 the macro only counts the figure 4, a - means a new year and you must not look further than there. However when the macro finds a / this is to be ignored and the macro reads on.
CD =3 points
C D =3points
D= 2 points
the figures are then added up to a maximum of 13
It is also important the macro places the results in the format given in the results spreadsheet, macros need to be able to handle several 1000's of rows of information.
Any questions please ask.