How to fill in range of blank rows wth data fr last row previos ra

G

Guest

Dear all,

I wish to know how could I fill in range of blank rows with the data of the
last row of the previous range. Eg. A1 contains APPLE, A2-A6 is blank A7
contains ORANGE A8-A12 is blank, A13 contains CHERRY and A14-A20 is blank. I
wish to fill is A2-A6 with APPLE, A8-A12 with ORANGE, and A14-A20 with
CHERRY. How can I do that?

Thank you very much in advance for your kind help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to copy info into blank cells within a column (going up the co 1
Help on filling empty cells with string + row() 1
Finding the Last Value in a Range 3
Data Entry - Write to next cell 3
How to sort AlphaNumeric Data sequentially with spaces 4
Select until blank row 8
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
how to copy the contents from last cell 2

Top