I need to write some kind of loop to check a cell for its contents and if the cell is empty then take the text from the cell to its left and insert to the most recent cell with a value.
That is screen shot sample of my worksheet. So for example, cell B3 is empty therefore I want the contents of A3 to be placed in A2. Also the contents of B12 are empty, so I want to take the contents of A12:A14 and place them together in one cell, A11 (because B11 contains the most recent number).
Any help would be greatly appreciated. Thank you!
That is screen shot sample of my worksheet. So for example, cell B3 is empty therefore I want the contents of A3 to be placed in A2. Also the contents of B12 are empty, so I want to take the contents of A12:A14 and place them together in one cell, A11 (because B11 contains the most recent number).
Any help would be greatly appreciated. Thank you!
Last edited:
