Adding a row in a table, while its position based on a cell in sorted column

[dikken20]

Hello,

I have a table with dozens of columns and hundreds of rows. This is a sample of the table to illustrate what I need:

View attachment 35956

Facts:
* I have two values as Keys: Name and Serial.
* Row B (=Name) is sorted.
* All values in the table (including Name) are initiated on another table by the Serial as a key.

What I need?
I need to add a row while its position is based on its "Name" and keeping all formulas of the row, meaning, copy formulas.
I would like to have some input window (maybe a form?) to insert the Name and Serial so it could complete the Adding Row task.

For example:
Name = DEF
Serial = 234567

Result will be the next:

In this example the row #5 inserted and all cells in this row (excluding the Serial) are formulas copied from row #4 (except from Serial which copied the same, meaning, not based on formula in the previous row)

How do I do that?
Thank you.

 

[Fluff]

Duplicate to: Adding a Row in a table cause an error

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.