How do I move only value producing formula to another column ??

s/s is very large and the need is to transfer formulas from one column to another.

Column L contains formulas in cells L7:L45 (attachment) - (L7:L326415 in working s/s).
Some of these formulas result in a value being given.
I need to transfer formulas only from those cells having values to cells three columns to the left on the same row.

I do have code which I was using for another application. This puts a formula in the correct places but it is the wrong formula and I don't know how to amend it so that it carries out the required action.

Anyone have code which can do this??
Small attachment enclosed for better understanding of what is involved.

Or could anyone change the line ".formula = ......" in the following code to make it work??

Please Login or Register  to view this content.

Big thanks.
Colwyn.

Copying a formula from col L to col I changes the results in col L; e.g., copying L7 to I7 causes L11 to change from "" to 1, which would cause L11 to be copied to I11, which causes L15 to change, ...

shg thanks, that's why I need code to do it.

I have code to fill in the appropriate cells but this was designed for another formula and I dont know how to modify it. The line of code in question is:

Please Login or Register  to view this content.

I want to modify this so as to give me the following formula in code:

=IF(AND(A3=I3,A3>0),VLOOKUP(J4,sheet2!L$2:M$11,2,FALSE),"")


If anyone can address this problem and provide the conversion the effort would be well appreciated.
Big thanks.
Colwyn.

Colwyn, the code isn't the problem; it's understanding what you want to happen.

Here's a guess:

Please Login or Register  to view this content.