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.
26 freelancers are bidding on average £106 for this job
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
I am a consultant to a London based Client to handle huge data sets, Handled global level P&L data, I am an expert in spreadsheet based models without using VBA. I can handle this request with efficient delivery