Need loop to copy value on a column until cell adjacent to it is blank.

Hi guys,

I'm new to this forum and am not really sure how should I start asking for help. Basically what I need is a macro that copies the value of the cell on top of a blank cell to the blank cell, provided that the cell two columns left of it is not blank.

This excel sheet is an example of what I'm trying to achieve:

Example.xlsx

Cheers and thanks all!

THB

Wow this works almost perfectly!

The only problem is I'm copying formulas for cell C. What would be the correct command for that?

Oh, which means right now the macro is only working for copying over values, but not formulas. How can I modify it to copy formula instead of just value?

Thanks so much