| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to fill in range of blank rows wth data fr last row previos ra
See this:
http://contextures.com/xlDataEntry02.html -- Biff Microsoft Excel MVP "Shinta Chen" <Shinta wrote in message ... 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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete blank rows (rows alternate data, blank, data, etc | Excel Discussion (Misc queries) | |||
| shifting of data to fill into blank cells | Excel Discussion (Misc queries) | |||
| Fill Blank cells in a range | Excel Discussion (Misc queries) | |||
| MACRO HELP - deleting rows containing a range of blank cells | Excel Discussion (Misc queries) | |||
| Hide columns & rows that contain "0" or blank in a range of cells | Excel Worksheet Functions | |||
Threaded Mode
