+ Reply to Thread
Results 1 to 4 of 4

Code to fill in blanks between entries in column

  1. #1
    Forum Contributor
    Join Date
    12-18-2011
    Location
    long island
    MS-Off Ver
    365
    Posts
    236

    Code to fill in blanks between entries in column

    I have a bunch of dates in column A at various different cell spacing's between them. I want a code that will run through column A and "fill in the gaps"
    For example, if i have a date in A1 and another date in A6 i want to fill in the blanks between A1 and A6 with the date in A1 (and the same thing with the date in A6 until the next date in column A)
    Ive attached an example sheet. My desired result is represented in column B (i dont need any actual output in column B. It is just and example)
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,885

    Re: Code to fill in blanks between entries in column

    try this

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Code to fill in blanks between entries in column

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    12-18-2011
    Location
    long island
    MS-Off Ver
    365
    Posts
    236

    Re: Code to fill in blanks between entries in column

    That worked
    Thank You!

+ 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. Need to fill blanks in a column
    By bclucas55 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-16-2014, 11:27 AM
  2. [SOLVED] Fill a column with a set string depending on number of entries in column.
    By skyping in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-29-2013, 08:12 AM
  3. [SOLVED] Macro to fill in missing blanks with data in a column
    By robertguy in forum Excel General
    Replies: 6
    Last Post: 10-19-2012, 02:49 AM
  4. Code to fill in blanks isn't working
    By thedon_1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2012, 07:36 AM
  5. Fill blanks in Column
    By LongArm in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-20-2010, 11:15 PM
  6. Auto Fill Entries in a column
    By finch2080 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-02-2005, 02:40 PM
  7. Copy selected cell in column and fill in blanks
    By Bluestar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2005, 10:28 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