Macro for horses racing based on results

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

2nd=3 points


4th=1 point

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.

Column F

CD =3 points

C D =3points

D= 2 points

C=1 point

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.

Beceriler: Excel

Daha fazlasını gör: macro e, horses, excel count, excel 2013 macro, macro spreadsheet, excel maximum column, excel macros spreadsheet macro, racing results spreadsheet, 1000 places spreadsheet, need excel macros, macro excel format, spread macro excel, excel macro form, rest based, macro format, macro excel total count, excel macro sheet, racing results, macro read excel, shows excel, read sheet excel, macro format excel sheet, macro excel sheet, excel format macro, macro excel column format

İşveren Hakkında:
( 55 değerlendirme ) Haverhill, United Kingdom

Proje NO: #4410594



Hi, your top-rated excel vba coder is ready to support you. regards,

%selectedBids___i_period_sub_7% gün içinde 60%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(18 Değerlendirme)

Please check your PM for details. Thanks

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(8 Değerlendirme)

7 freelancers are bidding on average $66 for this job


Seems interesting. I can take on the job. Let me know.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(54 Değerlendirme)

Hi there, Lets start asap....regards

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(18 Değerlendirme)

can provide you a quick macro for developing sheet2

in %bids___i_period_sub_35% gün içinde49%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)

Ready to do this.

in %bids___i_period_sub_35% gün içinde68%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I am a VB and macro code developer.I hope i can complete this project. Pls check the PM

in %bids___i_period_sub_35% gün içinde154%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)