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.
In addition, each time the IF function enters a value into U30, the new U30 value may modify the value in U31 and so on. Therefore the function must execute, then wait for U31 change, before it increments to next line down.
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
I have opened several conversations, each worded differently, but no one so far has been able to assist. I'm hoping that the language I'm using is not the reason no one has helped. Thank you however for your efforts.
