Excel programming

CLOSED
Bids
26
Avg Bid (GBP)
£106
Project Budget (GBP)
£20 - £250

Project Description:
using example on sheet, i am looking to automate an excel sheet used for tennis betting. All sheets will update automatically and must not be altered, except for Import sheet. Here, I will copy data as shown. The prices in "2" correspond to "away team" and "1" to "home team". Players may be imported in different orders etc.

THe prices in sheet Betangel (1) g9 and g11 are live prices for the player (or home/away team).

1) When price of player is lower on import sheet than live sheet, place "BACK" in the green shaded cell in column L on Bet Angel 1, corresponding to the same player. Place the amount as shown in the corresponding cell in g9 or g11 (using the example).

2) When price of player is higher on import sheet than live sheet, place "LAY" in the green shaded cell in column L on Bet Angel 1, corresponding to the same player. Place the amount as shown in the corresponding cell in g9 or g11 (using the example).

3) Repeat for 50 other matches, which will appear on bet angel (2), betangel (3) etc.

I don't want to have to write any information in, just import the data and it does its thing. I don't want VBA as i need to edit the info after.

Skills required:
Data Entry, Data Processing, Excel
Additional Files: Oddswizard+job.xls
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire bharanisrihari
£ 110
in 5 days
£ 263
in 4 days
Hire northwolves
£ 100
in 2 days
£ 121
in 7 days
£ 99
in 3 days
£ 97
in 3 days
£ 106
in 2 days
Hire Suri1
£ 44
in 1 days
£ 93
in 3 days
£ 149
in 5 days