+ Reply to Thread
Results 1 to 3 of 3

Quick way to fill up blank cells with preceding data

  1. #1
    Forum Contributor mikehk's Avatar
    Join Date
    09-05-2017
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    483

    Quick way to fill up blank cells with preceding data

    I wish to fill up cells with data in preceding cells. I am sorry, can't explain much
    in words so attaching a file sample with details. Please help.

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,343

    Re: Quick way to fill up blank cells with preceding data

    The quickest way to fill blanks in a data set to match the values in the rows above is to

    1) Select the column(s) of interest that you want to fill - in your case, B and D though you can select C as well
    2) Press Ctrl-G and choose Special... then choose "Blanks" and press OK
    3) Type =, press the up arrow key once, and press Ctrl-Enter.
    4) Select column B, copy, paste values
    5) Select column D, copy, paste Values
    6) fix your formatting

    To fix the February issue, you need to use a conditional in your date formula: in C2, use this

    =IFERROR(IF([@Day]="","",DATE($H$2,MONTH(C1)+IF([@Day]<B1,1,0),B2)),DATE($H$2,$I$2,[@Day]))

    Though once you fill B, there should be no need for the check for ""

    =IFERROR(DATE($H$2,MONTH(C1)+IF([@Day]<B1,1,0),B2),DATE($H$2,$I$2,[@Day]))
    Last edited by Bernie Deitrick; 02-06-2019 at 11:25 AM.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Forum Contributor mikehk's Avatar
    Join Date
    09-05-2017
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    483

    Re: Quick way to fill up blank cells with preceding data

    Thank you sooooooo much

+ 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. [SOLVED] Fill in blank cells with data on different column
    By rz6657 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2017, 07:06 PM
  2. Fill Blank Cells with Data if they contain a date
    By juanp21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2015, 12:08 AM
  3. quick way to fill in corresponding codes in blank cells?
    By tetrandra in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2013, 06:07 PM
  4. Replies: 7
    Last Post: 08-14-2013, 05:41 AM
  5. Fill blank cells with data directly above that blank cell
    By gibson2503 in forum Excel General
    Replies: 3
    Last Post: 06-05-2013, 10:07 AM
  6. How to color-fill blank cells, then once data is entered cell is no-fill
    By hatemail13 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-28-2013, 07:57 PM
  7. Fill in data from firt NON BLANK cells from Above:
    By smannon in forum Excel General
    Replies: 7
    Last Post: 07-29-2009, 07:45 AM

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