I would like to copy the first cell to the left of the active cell in a given row that is not blank then copy the contents to the original cell. Then I would like to move onto the next row and repeat. When all the cells to the left of the active cell are blank I would like the function to end.
Below is an example of the the data I am working with. I would like to populate each cell of the "most recent" column with the value of the first cell to the left of it that contains a value. The number of rows will not remain the same.
Month 1 Month 2 Month 3 Month 4 Most Recent 8 7 9 6 5 4 6 7 7
Any help with this would be great. Thank you
Bookmarks