Sedang Disiapkan

excel corrections to workbook, and vba makro needs altering slightly

this is a list of the known corrections / modifications that need making, I have attached a file ( sample 29th Dec file ) with data filled in and a clean sheet on which MUST do the modification, because it has been updated from sample file,

the majority of the project is small corrections to excel formulas, conditional formatting needs re-doing, and a couple of vba macros need adjusting to do slightly more, and want the workbook to be made as small as poss because I email it frequently, by removing unused macros etc

1………..Enter Values sheet………Pre [url removed, login to view] races code doesn't load to AH, all rest do so assume it is some sort of time issue,

also when 2 race meetings have same time on betfair it loads wrong one, need to make sure which one loads

2……….nofrillsbetfair sheet ………[url removed, login to view] button automatically logs in want the LOAD/REFRESH MARKETS button to do the same and refresh markets, which causes refresh pop up to appear twice and asks if I want to overwrite data, after 1st pop up the answer is no and after 2nd pop up the answer is yes, when refreshing if the race has run then the data is deleted and the race data is blank ( as on demo sheet [url removed, login to view] Donc race) , BUT I want it changed to not overwrite any race data were the race time is past as in column W in enter values sheet

3………..nofrillsbetfair sheet……….Press to record end prices macro needs changing to automatically log in and refresh market 1 min before each race time scheduled in column W of enter values sheet, and record it and not be overwritten by any more refreshes, presently when I select overwrite after refresh if the race has run then the data is deleted and the race data is blank

4………..races sheet……….conditional formatting ,need the colours to be exactly the same all through the sheet

The pink that highlights missing data and also column D & E when data missing needs changing from pink to pale yellow as in AI44

columns AC,AH,AI need reversing so highest number is best, using exactly the same colours green top ,pink lowest etc,

column AG needs colours reversing so 1 is top using exactly the same colours green top ,pink lowest,

column BC when 0 don’t want it to be highlighted,

column BH want the colours formatting the same as the other columns but not highlighting when there is 0 data

5………..races sheet……….AG ranking is equal to total of AC,AH,AI

7………..races sheet……….formula for AI needs amending so that AI = AC + flatstatshideP

e.g on 29th Dec sheet (AC539 = 1192) + ( flatstatshideP = 8% = [url removed, login to view] ) so AI 539 would = [url removed, login to view]

8………..races sheet……….at the min columns P43 AK43,AL43,BB43,BC43,BD43,BE43,BF43,BG43 have to be set as – so they add to the column AC, need those reversing so that whatever I add in % is added to column AC without using –

Think this is the formula as in BJ88 in demo sheet

=IF(D89"",totalbase+BA89-P89*P88-AE89*AE88-BB89*BB88-(BC89*10)*BC88-(BD89*10)*BD88-BG89*BG88-AK89*AK88-AL89*AL88-(BE89*10)*BE88-(BF89*10)*BF88+R89*R88,"")

9 ………..races sheet……….Column BH showing 1 when no data which then makes AH double so needs setting so no data = 0 but not highlighted red or included in D and E as missing data

10………..races sheet……….some columns are showing to more than 1 decimal point e.g AM56,AN56,AT56,AW56, etc and all the way down the sheet

11 …… dataformlatest sheet …………..remove hidden macro from between K1 and L1

12………..races sheet……….remove macro from BM 34

Remove unused modules etc

There is a macro somewhere that cleans the whole workbook out for me, if poss need that working again

There may be still be the odd corrections needed once these are done, that I can't check until the corrections above are done

Kemahiran: Pengaturcaraan C#, Pemasukan Data, Pemprosesan Data, Excel, Visual Basic

Lihat lebih lanjut: working betfair, vba load, highest ranking, ac press, vba time, me vba, excel sheet formula, end vba, vba macros, vba excel macro, vba e, think pink, sort excel, open meetings, makro, macro vba, excel w, excel macro vba, excel formulas, excel formula, excel formatting, excel vba, excel add, excel formula macro, bm

Tentang Majikan:
( 25 ulasan ) Leeds, United Kingdom

ID Projek: #4079779

Dianugerahkan kepada:

nayabsiddiqi

hi I'm expert in MS Excel, its Macros and utilizing its built-in functions. I can surely provide you best solution.

£44 GBP dalam 2 hari
(8 Ulasan)
4.2

5 pekerja bebas membida secara purata £104 untuk pekerjaan ini

sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

£150 GBP dalam 7 hari
(60 Ulasan)
5.7
expertatwork

We are a team of 2 having a vast experience on excel VBA scripting. Looking forward to work with you. thanks !!! Please have a look at our message in your PMB.

£95 GBP dalam 4 hari
(16 Ulasan)
3.6
eugene2006

Hi. I interested in your project.

£150 GBP dalam 5 hari
(9 Ulasan)
3.4
logoDS761

Hello, I am professional VBA coding and have high skills experience in all MS. Office applications; contact by pm please

£80 GBP dalam 5 hari
(0 Ulasan)
0.0