Im afraid it doesn't work. It doesn't recognizes netrang.
Is there another way?
--
ASU


"lar.ridge" wrote:

Try this code:
netrang = "H11:L11"
startrng = "H11"
Range(startrng) =
"=SUMIF($A$3:A3,A3,$H$11:H11)-SUMIF($A$3:A3,A3,$E11:E11)"
Range(startrng).AutoFill Destination:=Range(netrang), Type:=xlFillDefault

Larry

"ASU" wrote:

Yes , thats correct......eg. the formula in say "H11" is copied and pasted to
"H12". Like wise with cells "I11" through to "L11". The formula in "H11" is
as follows:

=SUMIF($A$3:A3,A3,$H$11:H11)-SUMIF($A$3:A3,A3,$E11:E11)

I'v tried dragging down, each column, to row 5000. But I found that it
slowed the file when opening and closing. Other way would to use vb codes to
do the maths!
--
ASU


"Dave O" wrote:

Allow me to re-state it, to make sure I understand it properly:
When the user enters data in the range H11:L11, a formula is copied and
pasted down one row automatically.

If that is correct, where is the formula that is copied? If my
restatement is wrong, please correct it.