Auto Fill macro when data varies

Alh14 Posts 1 Registration date Sunday July 9, 2017 Status Member Last seen July 9, 2017 - Jul 9, 2017 at 08:58 AM
I need to auto fill as a step in my macro but because the data will vary day to day it's breaking! Can someone help me?
I need to auto fill column b blanks with data from above in column b.
As soon as I complete the step and run the next day I'm getting a #ref

Thank you in advance!