Thanks for the reply, not quite. I know about Active Cell. I need more the current row

This will be pretty much static

Cell A1 = I will need the data value of the AD + currentro
Cell B1 = I will need the data value of the AE + currentro
Cell A2 = I will need the data value o fhte AF + currentro