Thread: If data exists in column J, put formula in column K
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default If data exists in column J, put formula in column K
Are you looking for this?

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

Rick


"S Himmelrich" wrote in message
...
the formula is basically:

=SUM(J1/MACRO!G11)

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

Reply With QuoteReply With Quote