View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
simplymidori[_2_] simplymidori[_2_] is offline
external usenet poster
 
Posts: 23
Default macro offset cell value and sum

Hello,

Looking to see if someone can help me with a macro.

If F ='TO SELL' find offset value located 4 rows above and in column AA -
copy value into columns G:U in the same row.

If column F='REMAINING' to subtract value (REMAINING (G:U) - TO SELL (G:U))

Thanks in advance