Forum Discussion
Create a macro saying...
Only make the first formula, and use copy and paste in correct direction in a select of 600 cells,
Its more simple
That could be
=IF((S30 > 0)*(R30 > 0), S30 ,"")
in U30, and drag it down
Not use $ because is for static cell address
Yes, I think I did what you describe here. I put =IF(($S30 > 0)*($R30 > 0), $U30=$S30,"") in an empty column and pasted it down. I believe it failed because it was functioning prematurely (before the full algorithm required its results). I need this to run near the end of a long process. So it needs to be a "CALL" from a macro I think.
Excel change automatic address cell in the correct way vertical and horizontal in multiple paste
=IF((S30 > 0)*(R30 > 0), S30 ,"")
While this worked, It deleted the formulas of column U30, So I think maybe a macro is required?
This also has to run after many other macros and formulas have run. So It has to be triggered from a macro I think.
Nope, that doesn't work, base on your latest post you need a macro, not formula
