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

S

Shinta Chen

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

Top