# Fill blank cells with data directly above that blank cell

1. ## Fill blank cells with data directly above that blank cell

I have a worksheet with columns A through D. There are over 345000 rows in this worksheet. Columns C and D have data in every row. I have pasted a sample below. I want to fill the blank cells in columnc A and B with the values above the blank cells. I tried going to cell A3 and typing =A2, then highlighting columns A and B, then "Go To", and selected "Blanks". However, after a few seconds, a box popped up saying that the selection was too large. Is there another way I can do this?

A B C D
13-05 MASON,AMANDA L MAR 19,2013 14:33 TAMER,MARIA A
MAR 19,2013 12:23 TAMER,MARIA A
MAR 19,2013 13:38 TAMER,MARIA A
MAR 19,2013 13:42 TAMER,MARIA A
MAR 19,2013 14:30 TAMER,MARIA A
MAR 20,2013 11:29 TAMER,MARIA A
MAR 20,2013 11:43 TAMER,MARIA A
MAR 21,2013 14:08 TAMER,MARIA A
MAR 21,2013 14:10 TAMER,MARIA A
MAR 21,2013 14:11 TAMER,MARIA A
13-05 MASON,KATHERINE A MAR 13,2013 16:45 TAMER,MARIA A
MAR 18,2013 10:39 TAMER,MARIA A
MAR 18,2013 12:16 TAMER,MARIA A
MAR 20,2013 12:24 TAMER,MARIA A
MAR 20,2013 13:56 TAMER,MARIA A
MAR 21,2013 10:26 TAMER,MARIA A

2. ## Re: Fill blank cells with data directly above that blank cell

Here's a bit of Excel magic:

Put your cursor in A1.
Press F5 (GoTo), click Special, click Current Region.
Press F5 again, click Special, click Blanks.
Begin to enter a formula by typing =
Click in the cell above the active cell (i.e. in A2)
Then do CTRL-Enter and your data will be filled.

Fix the values in those cells if you want to do something which moves the data around (like sorting).

Hope this helps.

Pete

3. ## Re: Fill blank cells with data directly above that blank cell

Hi Gibson,

A macro will do this work for you. Try this:
``Please Login or Register  to view this content.``

4. ## Re: Fill blank cells with data directly above that blank cell

hi dear friend
if I truly understood . the below code can help you . write it for a command button like CommandButton1
``Please Login or Register  to view this content.``

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1