Need Help with VBA script to make a value not change that is dependant on another Cell value

[Bond00]

So i need a way to have values in N column not change if i have an "L" in column L. values in N come from values in G + G*J% so if i change value in G from 2 to 22 it then changes value in corresponding cell in column N. i was thinking if i had some vba code to always copy the value from N to some other column like Q for example (a hidden column) and i could put a if then in column N so if L10="L" then N10=Q10 else SUM(G10+G10*J10%)

what is a simple vba script to copy N values from N10-N125 to Q10-Q125 but then not copy them if L10-L125 = "L" ? i think that would do the trick


Values in N have this going down =SUM(G10+G10*J10%)

G	H	I	J	K	L	M	N
2			11		L		2.22
4			12				4.48
5			13				5.65
7			11				7.77
8			12				8.96
9			12				10.08

<tbody>
</tbody>

 

[Joe4]

You are welcome.