If data exists in column J, put formula in column K

[S Himmelrich]

the formula is basically:

=SUM(J1/MACRO!G11)

J1, must change as formula moves down each row, "MACRO!G11" stays the
same

 

[Rick Rothstein \(MVP - VB\)]

Are you looking for this?

=SUM(J1/MACRO!$G$11)

Rick

 

[Conan Kelly]

S Himmelrich,

What about wrapping an IF() function around your formula?

Enter this formula in K1
=IF(J1="","",SUM(J1/MACRO!$G$11))

HTH,

Conan Kelly

 

[Dave Peterson]

Check your earlier post.

the formula is basically:

=SUM(J1/MACRO!G11)

J1, must change as formula moves down each row, "MACRO!G11" stays the
same

 

[S Himmelrich]

I've re-posted my original request to be more specific - sorry for the
lack of explaination in my original posting.

 

[S Himmelrich]

Solution:

Dim rng As Range
Set rng = Range(Cells(1, "D"), Cells(Rows.Count, "D").End(xlUp))
rng.Offset(0, 7).Formula = "=IF(J1="""","""",SUM(J1/MACRO!$G$11))"