Please help - I am trying to create a macro that works through a selected
range (loop, specifically a column) and finds empty cells and pastes the text
from the cell directly above it into the empty cell.
If anyone has an idea or an easier way to accomplish this it would be
appreciated.

Brandon