Q: How do i keep a row connected together(moving together) while shifting/adding row above it?

[ExcelLAd]

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`did is that each game that has launched status on `Teams` it gets on `Results` sheet and then`Results`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, here is my example:




**`Sheet1` `Teams`**
-


A B
1 **Names** **Status**


2 TEAM A Launched


3 TEAM B Pending


4 TEAM C Pending


5 TEAM D Launched






**2 `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



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 of TEAM D.


It will be like this:




**2 `Results`**
-

A B C D E
1 **Names** **1st Half goals** **2nd half** **total** **points**


2 TEAM A 1 2 3 13


3 TEAM B 3 1 4 10


4 TEAM D



Is there any solution to keep entire row moving together? please let me know.


This is the formula on `Sheet 2 Results` Cell `A2`
`=IFERROR(INDEX(TEAMS!A$2:A$550,SMALL(IF(TEAMS!B$2:B$550="Launched",ROW(TEAMS!B$2:B$550)-ROW(TEAMS!B$1)),ROW(TEAMS!B2))),"")`


and `Cell B & C & E` there is no formula only manual input, and for `Cell D` `=SUM(C2,B2)`

 

[ExcelLAd]

Am sorry i didn't notice that i have clicked on code and the thread is like that ... i can't find out how to edit it ? is it possible here or no ?

 

[ExcelLAd]

I guess its not clear that's why no one is replying, so I made the example clearer for you guys , so you can help:

Sheet1: Teams
​

	A	B
1	[FONT=&quot]Names[/FONT]	[FONT=&quot]Status[/FONT]
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	[FONT=&quot]Names[/FONT]	[FONT=&quot]1st Half goals[/FONT]	[FONT=&quot] 2nd Half[/FONT]	[FONT=&quot]Total[/FONT]	[FONT=&quot]Points[/FONT]
2	TEAM A	1	2	3	13
3	TEAM D	3	1	4	10

<tbody>
</tbody>

The problem occurs here , when a game between two started games, starts and shifts down the name to down , and gets the details of the row below it instead of being empty ...

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>

Please help !

 

[ExcelLAd]

Come on ! anyone ?? no one will help me ??!!