I'm not sure I follow your If-Then statement but this may help. This macro
uses the Worksheet_change event (right click the sheet tab, select View Code
and paste macro to the code sheet displayed).

If you enter a value in column B any blank cells immediately above the cell
just changed will be populated with the value of the last used cell in column
B.