I have a workbook with a number of sheets in it and I need to be able to automate updating one sheet with certain data when another sheet is updated.
Here is the layout:-
The data is all football matches from around the world, with with A being Date & Time, B being League, C being Match and G being Bet Type. If the data in those 4 columns is the same, then the match is the correct one in both sheets. This only really matters for data that is updated in the original sheet, not data that is originally input, if that makes sense.
The original sheet is called Value Betting and the sheet to be updated is called VB Daily Summary. All the data in Value Betting is added by copying and pasting it from downloaded data.
What I want to happen is that when I add data to a row of data in Value Betting, the same data is then added to VB Daily Summary. As the result is not know at the time of the data being originally input, a W or L is subsequently added to the relevant Value Betting column; this then need to update the same match in VB Daily Summary.
Columns A - J contain the data which is manually added or updated in Value Betting. The remaining columns to the right update already based on formulas, so they are of no concern - it is just A - J.
So I need columns A - J to update in VB Daily Summary as they are updated in Value Betting. When the data is initially added to Value Betting, it will also add to VB Daily Summary. When data is then updated in Value Betting...let's say the odds for a match change or the W or L is added, that is when Columns A, B, C & G need to match, if that makes sense.
Here is a typical scenario; all data from A - J is added Value Betting. The following day, either the odds have changed, or the result is known and those two columns are updated. The column for odds is I and the column for Result is J. When they update, it needs to update in the same match in VB Daily Summary.
The file is stored in a Dropbox folder on my Mac, as it is shared with another team member.
Here is the original Value Betting sheet showing columns A - J.
Any help in this will be greatly appreciated.
Here is the layout:-
The data is all football matches from around the world, with with A being Date & Time, B being League, C being Match and G being Bet Type. If the data in those 4 columns is the same, then the match is the correct one in both sheets. This only really matters for data that is updated in the original sheet, not data that is originally input, if that makes sense.
The original sheet is called Value Betting and the sheet to be updated is called VB Daily Summary. All the data in Value Betting is added by copying and pasting it from downloaded data.
What I want to happen is that when I add data to a row of data in Value Betting, the same data is then added to VB Daily Summary. As the result is not know at the time of the data being originally input, a W or L is subsequently added to the relevant Value Betting column; this then need to update the same match in VB Daily Summary.
Columns A - J contain the data which is manually added or updated in Value Betting. The remaining columns to the right update already based on formulas, so they are of no concern - it is just A - J.
So I need columns A - J to update in VB Daily Summary as they are updated in Value Betting. When the data is initially added to Value Betting, it will also add to VB Daily Summary. When data is then updated in Value Betting...let's say the odds for a match change or the W or L is added, that is when Columns A, B, C & G need to match, if that makes sense.
Here is a typical scenario; all data from A - J is added Value Betting. The following day, either the odds have changed, or the result is known and those two columns are updated. The column for odds is I and the column for Result is J. When they update, it needs to update in the same match in VB Daily Summary.
The file is stored in a Dropbox folder on my Mac, as it is shared with another team member.
Here is the original Value Betting sheet showing columns A - J.
| Best Bets Tracker_personal v3.1.xlsx | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | |||
| 1940 | 26 May 2024 19:45 | (Italy) Serie A | Lazio vs Sassuolo | 5.9 | 1.32 | Betfair | Draw | 70.2 | 5.9 | W | ||
| 1941 | 26 May 2024 21:00 | (Brazil) Serie B | Vila Nova vs Brusque | 1.73 | 0.07 | Betfair | Home | 35.14 | 1.74 | L | ||
| 1942 | 26 May 2024 22:30 | (Brazil) Serie B | Ceará vs Chapecoense | 1.66 | 0.04 | Betfair | Home | 37.14 | 1.7 | W | ||
| 1943 | 26 May 2024 23:00 | (Colombia) Liga BetPlay | Santa Fe vs La Equidad | 3.55 | 0.28 | Betfair | Draw | 70.2 | 4 | L | ||
| 1944 | 27 May 2024 00:00 | (Ecuador) Liga Pro | Orense vs Cumbaya | 1.55 | 0.07 | Betfair | Home | 47.27 | 1.55 | W | ||
| 1945 | 27 May 2024 14:00 | (Egypt) Premier League | Pyramids FC vs El Gounah | 5.7 | 1.61 | Betfair | Draw | 70.2 | 5.4 | L | ||
| 1946 | 27 May 2024 18:00 | (Bulgaria) First League | Botev Plovdiv vs Arda | 3.9 | 0.43 | Betfair | Draw | 70.2 | 4 | L | ||
| 1947 | 27 May 2024 18:00 | (Bulgaria) First League | Slavia Sofia vs CSKA 1948 Sofia | 3.85 | 0.34 | Betfair | Draw | 70.2 | 3.85 | L | ||
| 1948 | 29 May 2024 18:00 | (Norway) Eliteserien | Bodø / Glimt vs Sandefjord | 7 | 1.63 | Betfair | Draw | 70.2 | 7.6 | W | ||
| 1949 | 29 May 2024 18:00 | (Norway) Eliteserien | Brann vs Kristiansund | 8.2 | 2.31 | Betfair | Draw | 70.2 | 8.2 | L | ||
| 1950 | 29 May 2024 18:00 | (Norway) Eliteserien | Tromsø vs Fredrikstad | 1.81 | 0.13 | Betfair | BTTS - Yes | 0 | 0 | L | ||
| 1951 | 30 May 2024 00:30 | (United States) Major League Soccer | Inter Miami vs Atlanta United | 5.3 | 1.32 | Betfair | Draw | 70.2 | 5.3 | L | ||
| 1952 | 30 May 2024 03:30 | (United States) Major League Soccer | LA Galaxy vs Dallas | 4.6 | 0.61 | Betfair | Draw | 70.2 | 4.7 | L | ||
| 1953 | 30 May 2024 03:45 | (United States) Major League Soccer | Los Angeles FC vs Minnesota United | 1.54 | 0.04 | Betfair | Home | 48.15 | 1.55 | W | ||
| 1954 | 30 May 2024 03:30 | (United States) Major League Soccer | Seattle Sounders vs Real Salt Lake | 4.000 | 0.18 | Betfair | Draw | 70.2 | 4 | W | ||
| 1955 | 31 May 2024 16:00 | (Finland) Veikkausliiga | SJK vs Mariehamn | 4.4 | 0.76 | Betfair | Draw | 70.2 | 4.5 | |||
| 1956 | 31 May 2024 18:00 | (Denmark) Superliga | FC Copenhagen vs Randers | 5.2 | 1.01 | Betfair | Draw | 70.2 | 5.4 | |||
| 1957 | 31 May 2024 18:00 | (Finland) Veikkausliiga | Oulu vs HJK | 4.3 | 0.64 | Betfair | Draw | 70.2 | 4.4 | |||
| 1958 | 01 Jun 2024 00:30 | (United States) Major League Soccer | New York City vs SJ Earthquakes | 4.3 | 0.25 | Betfair | Draw | 70.2 | 4.4 | |||
Value Betting | ||||||||||||
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| D1:E1958 | Cell Value | >0 | text | NO |
Any help in this will be greatly appreciated.
