| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically fill blank cell by same as just above record
Is there a way we could use excel to fill up any blank with just above
cell's data? For example, I have a data as below: A B ID Details 22 ABC 22 ABC Blank Blank 66 COM 66 COM Blank Blank 29 TTT 29 TTT Blank Blank I have over 1000 lines for this.. Could you please help me with macro details.. or instruction?? I'm also thinking using find-replace function. but don't know how to indicate cell above or function. I'm using MS Excel2000 and 2003. Thank you so much!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically fill in blank cells?? | Excel Worksheet Functions | |||
| Fill column blanks from last non-blank cell | Excel Discussion (Misc queries) | |||
| Fill cell that is blank | Excel Worksheet Functions | |||
| automatically insert 8 blank rows between each record | Excel Discussion (Misc queries) | |||
| How do I automatically fill a cell based on another cell in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
