Results 1 to 4 of 4

Code to fill in blanks between entries in column

Threaded View

  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

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