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