paulette33
Technical User
Hi -
I have a column with a series of values and empty cells in between. When I find a cell with value and empty cells following, I want to copy that value into the empty cells. I need to do this for the entire column. What is the easiest way to do this without have to manually autofill or copy and paste.
I've gotten a Do Loop to cycle through the cells looking for the empty cell and can copy that until it reaches the next cell with value. But, how do I get it to continue until it has gone through the entire column?
Hope this makes sense and thanks in advance!
I have a column with a series of values and empty cells in between. When I find a cell with value and empty cells following, I want to copy that value into the empty cells. I need to do this for the entire column. What is the easiest way to do this without have to manually autofill or copy and paste.
I've gotten a Do Loop to cycle through the cells looking for the empty cell and can copy that until it reaches the next cell with value. But, how do I get it to continue until it has gone through the entire column?
Hope this makes sense and thanks in advance!