Hello all Im new to the forum. Working for a Fortune 500 Co as a
Accountans Assist. I basicaly write macros/VBAs' to streamlin
processes.

Q. Is there a way to right this
"=IF(A7=A6,
",SUMIF(A$7:A$1422,A7,C$7:C$1422)-SUMIF(A$7:A$1422,A7,D$7:D$1422))"

in a VBA script. I want to paste this in ("E7") then copy down
After copy and paste back values so that slow cpu's won't have t
recalc every time any small changes are made.

(A) (B) (C) (D)
(E)
(6) REF# BR DEBIT CREDIT DIFF
(7) 4920 10 278.93 226.88
(8) 4920 10 278.93
(9) 4920 10 226.88
(10) 8123 10 64.84 64.84
(11) 8133 10 70.12 70.12
(12) 8134 10 43.83 43.83
(13) 8158 10 63.18 63.18
(14) 8217 10 36.60 36.60
(15) 8253 10 143.69 143.69
(16) 8303 10 158.81 158.81
(17) 8327 10 317.63 317.63
(18) 8359 10 80.33 80.33
(19) 8360 10 26.30 26.30


Thanks for the hel

--
LeeBoWad
-----------------------------------------------------------------------
LeeBoWadd's Profile: http://www.excelforum.com/member.php...fo&userid=1655
View this thread: http://www.excelforum.com/showthread.php?threadid=31409

Range("E7:E30").Formula = _
"=IF(A7=A6,"""",SUMIF(A$7:A$1422,A7,C$7:C$1422 )" & _
"-SUMIF(A$7:A$1422,A7,D$7:D$1422))"

--
Regards,
Tom Ogilvy

"LeeBoWadd" wrote in message
...

Hello all Im new to the forum. Working for a Fortune 500 Co as an
Accountans Assist. I basicaly write macros/VBAs' to streamline
processes.

Q. Is there a way to right this
"=IF(A7=A6,"
",SUMIF(A$7:A$1422,A7,C$7:C$1422)-SUMIF(A$7:A$1422,A7,D$7:D$1422))"

in a VBA script. I want to paste this in ("E7") then copy down.
After copy and paste back values so that slow cpu's won't have to
recalc every time any small changes are made.

(A) (B) (C) (D)
(E)
(6) REF# BR DEBIT CREDIT DIFF
(7) 4920 10 278.93 226.88
(8) 4920 10 278.93
(9) 4920 10 226.88
(10) 8123 10 64.84 64.84
(11) 8133 10 70.12 70.12
(12) 8134 10 43.83 43.83
(13) 8158 10 63.18 63.18
(14) 8217 10 36.60 36.60
(15) 8253 10 143.69 143.69
(16) 8303 10 158.81 158.81
(17) 8327 10 317.63 317.63
(18) 8359 10 80.33 80.33
(19) 8360 10 26.30 26.30


Thanks for the help


--
LeeBoWadd
------------------------------------------------------------------------
LeeBoWadd's Profile:
http://www.excelforum.com/member.php...o&userid=16552
View this thread: http://www.excelforum.com/showthread...hreadid=314096