title: Loop to find an empty cell in a column, then copy the cell above the empty cell into the empty cell
body: <p>I have a SAP report in Excel with over 10,000 rows. There are 2 columns - A &amp; B. A is value in $ and B is ref for the value. The SAP report shows subtotals by reference type but the subtotal ref cell B is always empty. I need to copy the cell above the empty cell into the empty cell (into the same row as the subtotal). e.g. A1:A5 has values 3,2,3,1,1 so the subtotal is 10 and it's in A6. the cell in B6 is empty. The ref type in B5 is 12kg Bag. I need to copy this ref into Cell B6. the reason why i do this is because i filter the report by subtotal to copy to another file. At the moment I'm doing this manually and it takes ages. I'm guessing it's a loop code until the last row as the rows vary each time i run the report. Thank you!</p>