Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatically fill in blank cells?? AlaskaMX Excel Worksheet Functions 6 September 5th 06 05:32 PM
Fill column blanks from last non-blank cell C. BROWN Excel Discussion (Misc queries) 2 August 28th 06 08:36 PM
Fill cell that is blank Slashman Excel Worksheet Functions 7 August 28th 06 01:30 AM
automatically insert 8 blank rows between each record Evad Excel Discussion (Misc queries) 1 February 2nd 06 05:35 AM
How do I automatically fill a cell based on another cell in Excel SouthCarolina Excel Discussion (Misc queries) 3 January 13th 06 01:52 AM


All times are GMT +1. The time now is 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"