Just need a few Excel macros written
## Deliverables
Hi,
Attached is an excel file, for which I need a couple of macros written as follow.
On the "Arb Calc" tab, I need 2 buttons added to the top right of the blue square. One button is to be labeled "Clear" and the other "Place Bets".
The "Clear" button will simply clear everything in the white fields back to empty.
The "Place Bets" Button, needs to do 3 things:
1. Enter the relevant data into the "Pending Results" tab. The row in which it will be entered is directly below the lowest current row. Please note, that it is possible that "Date", "Time" and "Event" field may be blank, but the "Amount" field under "Book 1" will never be, so you can use this to gauge the last entry. The data map can be found below.
2. Clear everything on this tab as per the “Clear?? button.
3. Find the “Book?? in the “Summary?? tab that corresponds to F11, and deduct either F21 from the $ column if F21 is not blank, or if it is blank, then deduct F19 from the $ column. Do the same for H, J, L, N and P columns.
The following maps which fields from the "Pending Results" tab correspond to which fields on the "Arb Calc" tab.
* A N6
* B N7
* C N5
*
* D F11
* E F13
* F F15
* G F17
* H if F21 not blank, F21, else F19
*
* J H11
* K H13
* L H15
* M H17
* N if H21 not blank, H21, else H19
*
* P J11
* Q J13
* R J15
* S J17
* T if J21 not blank, J21, else J19
*
* V L11
* W L13
* X L15
* Y L17
* Z if L21 not blank, L21, else L19
*
* AB N11
* AC N13
* AD N15
* AE N17
* AF if N21 not blank, N21, else N19
*
* AH P11
* AI P13
* AJ P15
* AK P17
* AL if P21 not blank, P21, else P19
I also require some buttons with macros in the “Pending Results?? tab. These buttons should be located in every row from 3 to 100, in columns I, O, U, AA, AG, AM, and they should be labelled “Win??. When the win button is pressed, the following actions should occur…
1. The entire row should be copies to the next available row of the “Archive?? tab, and the “Winner?? column corresponding to the button that was pressed should have a “y??.
2. In the “Summary?? tab, the $ column corresponding to the “Book?? which “won?? should be increased by the following formula: (Odds x Amount) ??" ((Odds -1) x Amount x Commission)
3. The entire row on the “Pending Results?? tab should be cleared, and each below it should be shuffled up 1 to fill it’s place. If this is too difficult, please let me know, and I have a plan B.