Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to fill in range of blank rows wth data fr last row previos ra
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. |
#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. |
Reply |
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 |