View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default If data exists in column J, put formula in column K

Check your earlier post.

S Himmelrich wrote:

the formula is basically:

=SUM(J1/MACRO!G11)

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


--

Dave Peterson