I have a specific range on my sheet e.g. ("G10:G21"). (12 cells)
Within the range I’m expecting a variable No. of cells to be filled, but at the bottom of the range. It may have only 1 cell filled, or 11 filled. But there will always be a blank at the top in G10.
What I want to do is fill cell G10 with the initial text, that I can then increment down to the last Blank cell in the range.
E.g. cell G10 = “Test 1”, G11 will autofill “Test 2”, G12 will autofill “Test 3” etc. filling only the blank cells and stopping at the first filled cell.
Any help appreciated.
Within the range I’m expecting a variable No. of cells to be filled, but at the bottom of the range. It may have only 1 cell filled, or 11 filled. But there will always be a blank at the top in G10.
What I want to do is fill cell G10 with the initial text, that I can then increment down to the last Blank cell in the range.
E.g. cell G10 = “Test 1”, G11 will autofill “Test 2”, G12 will autofill “Test 3” etc. filling only the blank cells and stopping at the first filled cell.
Any help appreciated.