Closed

Excel programming

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: Data Entry, Data Processing, Excel

See more: vba programming using excel, vba programming in excel, vba excel programming, programming in vba, programming in excel vba, programming in excel 2013, programming home, price for vba for excel, live programming, home programming, excel programming vba, bet programming, excel 2013 vba, need programming team, live betting, excel automate, vba excel copy, vba update excel, data processing vba, excel vba processing, vba edit, automate excel update, using vba automate data entry, vba data processing, live excel data

About the Employer:
( 0 reviews ) United Kingdom

Project ID: #4485227

26 freelancers are bidding on average £106 for this job

bharanisrihari

Hello, Excel & Word VBA expert here. Please check PM for details. Thanks!

£110 GBP in 5 days
(60 Reviews)
6.4
srinichal

Looking forward to deliver the project

£263 GBP in 4 days
(12 Reviews)
4.8
northwolves

Ready to [url removed, login to view] forward to working with you.

£100 GBP in 2 days
(32 Reviews)
4.6
jal540

I have extensive experience in Excel 2003/2007/2010 and excellent ratings.

£121 GBP in 7 days
(11 Reviews)
4.2
priyal1997

Dear Sir.. Please check PM and Confirm. Thanks - Priyal

£99 GBP in 3 days
(15 Reviews)
3.9
vikashgadia

excel macro expert ....

£97 GBP in 3 days
(15 Reviews)
3.6
vickkey7

I am ready to start this project.... thanks

£106 GBP in 2 days
(9 Reviews)
3.4
Suri1

Dear Chriswillcock, Excel pro here with great knowledge in Formulas & Functions. Please check my previous ratings regarding Excel tasks to know more. More details in PM Thanks

£44 GBP in 1 day
(7 Reviews)
3.3
JScottArnold

I am an Excel guru with years of experience in both Excel and sports website scraping. I'd love to chat more about this work!

£93 GBP in 3 days
(1 Review)
2.8
Evs1

***We exist in world's Top 10 Virtual Assistant & Data Entry Companies*** Please check PMB for complete details.

£149 GBP in 5 days
(5 Reviews)
2.5
epdailo

This looks like a simple project. I would like to take a shot at his.

£23 GBP in 7 days
(2 Reviews)
2.2
amitchaps

[url removed, login to view] In [url removed, login to view] check PM for details.

£99 GBP in 2 days
(1 Review)
1.0
mpunn2007

lets do it.

£23 GBP in 1 day
(1 Review)
0.0
Fanilo2312

I'm good in excel. Please take on account my skills!Thanks

£23 GBP in 2 days
(0 Reviews)
0.0
Rajmohan007

Hi Sir, Please check our private message. Hoping to work with you Regards, Athena software Solutions team

£99 GBP in 3 days
(0 Reviews)
0.0
npraba1

NOthing to say...Only working....

£111 GBP in 3 days
(0 Reviews)
0.0
NhatAnhIT

I very impressive with your project. I ensure i do it very well. Please check my pm !

£88 GBP in 2 days
(0 Reviews)
0.0
alphaedge999

I am interested in this project.

£148 GBP in 3 days
(0 Reviews)
0.0
DRMINGLE

I am an expert with Microsoft Excel and VBA. In addition, I am great project communicator.

£148 GBP in 3 days
(0 Reviews)
0.0
johnfabraham

I am a pro in advanced excel and do this kind of work for a living

£148 GBP in 3 days
(0 Reviews)
0.0