Manual cells don't follow the automatically moving formula cells.

[Pablo Espressobar]

Hi Everyone,

I've got an Excel Table that contains different columns of data. Some rows have formulas in it, some of them have data i input manually.
Example: (You can find the Formula below the table, because it's a little long)

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Serial[/TD]
[TD]Quantity[/TD]
[TD]Hours[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]Formula[/TD]
[TD]a12[/TD]
[TD]10[/TD]
[TD]4[/TD]
[TD]="Hours"*10[/TD]
[/TR]
[TR]
[TD]Formula[/TD]
[TD]b34[/TD]
[TD]20[/TD]
[TD]12[/TD]
[TD]="Hours"*10[/TD]
[/TR]
[TR]
[TD]Formula[/TD]
[TD]c56[/TD]
[TD]30[/TD]
[TD]36[/TD]
[TD]="Hours"*10[/TD]
[/TR]
[TR]
[TD]Formula[/TD]
[TD]d78[/TD]
[TD]40[/TD]
[TD]18[/TD]
[TD]="Hours"*10[/TD]
[/TR]
</tbody>[/TABLE]

Formula: =IFERROR(INDEX($C$3:$C$1000;SMALL(IF(NOT(ISBLANK($T$3:$T$1000));ROW($T$3:$T$1000)-ROW($T$3)+1;IF(NOT(ISBLANK($W$3:$W$1000));ROW($W$3:$W$1000)-ROW($W$3)+1;IF(NOT(ISBLANK($Z$3:$Z$1000));ROW($Z$3:$Z$1000)-ROW($Z$3)+1)));ROW(T5)));"")

The formula is searching another excel table for content (I've deleted the addressing to make it more readable). If it finds data in the arrays listed then it copies the data from the actual row of C3:C1000 into my table. If it finds a blank cell it skips it. So basically it makes a small table from a big one.

So now that you know the background let me explain my problem.

If the formula finds a new row E.G. between "c56" and "d78", then it shifts d78 down and places the new row to it's place. In this case my manually added data stays on its place and doesn't follow its Name and Price.
Is there any way to bound these cells together if i add the Manual data?
Any suggestions appriciated, i'm familiar with VBA too.

Regards,
Pablo