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!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically fill blank cell by same as just above record
In C2 put the following :
=IF(A2="",A1,A2) In D2 put the following: =IF(B2="",B1,B2) Copy both columns down as required. Copy, Paste Special--Values (columns C & D) and delete columns A & B Test first! HTH " wrote: 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!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically fill blank cell by same as just above record
F5SpecialBlanksOK
Type = sign in active blank cell then point or arrow up to cell above. Hit CTRL + ENTER. CopyPaste SpecialValuesOKEsc. Gord Dibben MS Excel MVP On 3 Mar 2007 00:19:04 -0800, wrote: 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!! |
Reply |
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) |