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!!

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!!

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!!