Hello guys,
So I have an Excel file containing two sheets:
- `Teams` (which contains details of teams and time schedule of their matches)
- `Results` (contains calculation and number of matches and results, etc).
What`Results`does is that each game that has launched status on `Teams` it gets on `Results` sheet and then`Results` I input the number and calculation on that sheet.
My problem is that when there is a game inside two started games, when it starts the new name comes and shifts the name row below it and keeps the details of the row below it for itself, while it should be to next of it, If you confused or did not get my question , here is my example it will be more clear:
<tbody>
</tbody>
<tbody>
</tbody>
So what happens here is that if change the status of TEAM B on `Sheet1` of `Teams` it will be appear on 2 `Results` and it will take the row input&data of TEAM D. Like this:
Sheet2: Results (The problem)
<tbody>
</tbody>
So what can I do to make TEAM D keep the data of entire row while TEAM B shifts it ??
Please help
So I have an Excel file containing two sheets:
- `Teams` (which contains details of teams and time schedule of their matches)
- `Results` (contains calculation and number of matches and results, etc).
What`Results`does is that each game that has launched status on `Teams` it gets on `Results` sheet and then`Results` I input the number and calculation on that sheet.
My problem is that when there is a game inside two started games, when it starts the new name comes and shifts the name row below it and keeps the details of the row below it for itself, while it should be to next of it, If you confused or did not get my question , here is my example it will be more clear:
Sheet1: Teams
| A | B | |
| 1 | Names | Status |
| 2 | TEAM A | Launched |
| 3 | TEAM B | Pending |
| 4 | TEAM C | Pending |
| 5 | TEAM D | Launched |
<tbody>
</tbody>
Sheet2: Results
| A | B | C | D | E | |
| 1 | Names | 1st Half goals | 2nd Half | Total | Points |
| 2 | TEAM A | 1 | 2 | 3 | 13 |
| 3 | TEAM D | 3 | 1 | 4 | 10 |
<tbody>
</tbody>
So what happens here is that if change the status of TEAM B on `Sheet1` of `Teams` it will be appear on 2 `Results` and it will take the row input&data of TEAM D. Like this:
Sheet2: Results (The problem)
| A | B | C | D | E | |
| 1 | Names | 1st Half Goalss | 2nd Half | Total | Points |
| 2 | TEAM A | 1 | 2 | 3 | 13 |
| 3 | TEAM B | 3 | 1 | 4 | 10 |
| 4 | TEAM D |
<tbody>
</tbody>
So what can I do to make TEAM D keep the data of entire row while TEAM B shifts it ??
Please help
