+ Reply to Thread
Results 1 to 2 of 2

Fill Blank Cells with Data if they contain a date

  1. #1
    Registered User
    Join Date
    06-16-2014
    Location
    TX
    MS-Off Ver
    2010
    Posts
    27

    Fill Blank Cells with Data if they contain a date

    Hello

    I was wonderig if this is possible. I would like to fill the blank cells in column B with the value to the right in Column C.

    Only blank cells. If its not blank it should stay the same.


    Can a constraint be added so only cells that contain a date are copied. If its not a date it should remain blank .


    Any suggestion or advise is apreciated

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Fill Blank Cells with Data if they contain a date

    Try this.....

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ 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 Blank Cells in Columns with Specified Header with a Specific Date
    By uberathlete in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2014, 10:43 PM
  2. 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
  3. 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
  4. 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
  5. Auto fill blank cells with data in a cell above
    By StudentMod in forum Excel General
    Replies: 4
    Last Post: 05-09-2008, 04:37 PM

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