I am looking to put a vba formula into all cells of a column(column B), and populate column B based on the value of another column A. I am having difficulty referencing the previous cell up in a column to get its value when there are blank rows involved. Here is my example:
Col A.........Col B
<seed>.....Section 5
123...........Section 5-1
xyz...........Section 5-2
456............Section 6-1
def.............Section 6-2
abc............Section 7-1
Col A.........Col B
<seed>.....Section 5
123...........Section 5-1
xyz...........Section 5-2
456............Section 6-1
def.............Section 6-2
abc............Section 7-1