+ Reply to Thread
Results 1 to 5 of 5

Fill blank cells in column with value in the column below blank cells

  1. #1
    Forum Contributor
    Join Date
    10-24-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2013
    Posts
    286

    Fill blank cells in column with value in the column below blank cells

    Anyone have code that would look at a column and select the blank cells and fill them with the first cell that has data in it below the blank cells? I know how to do it by selecting the range and clicking F5 selecting blanks and using the formula to populate them all using a the cell above the blank cell. But in this case the cell with the data is below the blank cell. I have entities down the page for one GL account with the GL account at the bottom of the entity list. I want to fill all the rows above it for each entity. There are a hundred or so accounts down the data set. I want to be able to create a pivot off of the data once all the blank cells are populated but having the cell below is making it harder for me.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,684

    Re: Fill blank cells in column with value in the column below blank cells

    If you know how to do it manually from the cell above (and CTRL-Enter to apply the formula to all the blank cells), then you can do what you want by using the cell immediately below the first blank cell in the formula.

    Hope this helps.

    Pete

  3. #3
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Fill blank cells in column with value in the column below blank cells

    Can't you do the same thing by selecting the blank cells and type in the formula for the cell below instead of the cell above, then press CTRL + Enter to fill them all in?
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.

  4. #4
    Forum Contributor
    Join Date
    10-24-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2013
    Posts
    286

    Re: Fill blank cells in column with value in the column below blank cells

    ahhh. Thanks. I was scrolling all the way down and selecting the first populated cell. Makes sense.

  5. #5
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: Fill blank cells in column with value in the column below blank cells

    If the blank cells in column C.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatically scrolling down a column to fill blank cells
    By lbl159 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-04-2015, 03:15 PM
  2. Fill Blank Cells in a Column with Formula
    By uberathlete in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2014, 03:29 PM
  3. Auto fill macro when adjacent column has blank cells
    By ElsiePOA in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-30-2014, 09:49 PM
  4. [SOLVED] Macro to fill blank cells in column A based on non-blank cells
    By ktalamantez in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2014, 02:47 PM
  5. Fill blank cells in column with value above
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-19-2012, 09:46 AM
  6. How to fill blank cells with different values in a column
    By intermine in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2010, 12:43 AM
  7. how can i fill blank cells in column with abc while the right col.
    By khurram saddique in forum Excel General
    Replies: 2
    Last Post: 02-12-2005, 12:06 PM

Tags for this Thread

Bookmarks

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