Automatically fill blank cell by same as just above record

  • Thread starter Thread starter funtae
  • Start date Start date
F

funtae

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!!
 
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
 
F5>Special>Blanks>OK

Type = sign in active blank cell then point or arrow up to cell above.

Hit CTRL + ENTER.

Copy>Paste Special>Values>OK>Esc.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill in Blanks with immediately above cell value 8
Fill blanks down column with cell above 2
problem filling in blank cells with data above - 1
Need data result in last cell of array that contains blank cells 2
Need macro to move to first blank cell in column 6
find blank cell and replace with " ' " 2
How do I auto fill blanks cells immediately below with the same i. 2
Data in cell disappears, reappears by scrolling mouse over cell 3

Back
Top