| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill/Copy Up to fill blank cells.
I have a list of data in column B. Every few lines there is a blank.
In any instance of a blank cell, I want a code that will copy from the value from the cell below and paste it into the blank cell. The opposite of the fill/copy down code that would copy the last value. ex: apples cherries blueberries plums mangos kiwi Desired result: apples cherries blueberries plums plums mangos kiwi The code found plums below the blank space so it copies and plugs that value in. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FILL IN BLANK CELLS | Excel Discussion (Misc queries) | |||
| The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
| Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
| Copy value and fill blank spaces below it until new value is encountered? | Excel Programming | |||
| Fill blank cells with 0 | Excel Programming | |||
Threaded Mode
