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.