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

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:

1.png

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:

2.png

So what can I do to make TEAM D keep the data of entire row while TEAM B shifts it ??
Please help

Note:

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)`

P.S: I have posted same thread on MrExcel Chandoo and Stackoverflow (which was the main reason behind why I posted on other forums)

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

I do not think that you have read our forum rules yet.

Rule 08: Cross-posting Without Links

Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

No further help to be offered, please, until the OP has complied with this request.

Hello,

Please accept my apologies, i didn't read it, I completely understand what you mean, but cross posting doesn't always mean I will leave my thread on other forums when i find the answer, actually am planning to post the solution to every single forum that i have posted and give credit to whom have helped me , I always do that.

Now the main reason why I posted this on this & other forums is , i don't usually do cross posting, but if you check my thread, i started a thread on stackoverflow 7 days ago and they did not help me and left me with no answer, personally any delay for my work is very bad for me, and I need to know If there is a possible solution so I can use ASAP, am desperately checking all of my threads on all forums each 30-40 min.


I have edited my post, now you can see where my threads are, hopefully you would be able to help.

sorry for inconvenience again.
Thanks

Thank you. The issue is NOT with cross-posting per se - it's fine for you to do that - but ALL of the forums where you have posted require you to provide links if you do, regardless of your intentions. Thank you for your compliance.

You have provided the links requested - that's it. Now you just need to be patient and hope that someone can help.

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.