+ Reply to Thread
Results 1 to 2 of 2

autoFill rows in excel from given input

  1. #1
    Registered User
    Join Date
    04-29-2009
    Location
    Lafayette, Indiana
    MS-Off Ver
    Excel 2003
    Posts
    1

    autoFill rows in excel from given input

    Is there a way to fill rows in excel with given input values? for tens of thousand rows

    across several different files given over 400 input values: So I need to fill cell A2 with Ander all the way down to next team take that team name fill it all the way down to next team etc, etc, etc
    Example: (The dates are in col B team names in ColA)
    Starting Data Desired Result
    ColA ColB ColA ColB
    Ander 11/1/2007 Ander 11/1/2007
    11/5/2207 Ander 11/5/2207
    11/16/2007 Ander 11/16/2007
    12/4/2007 Ander 12/4/2007
    12/8/2007 Ander 12/8/2007
    12/27/2007 Ander 12/27/2007
    1/7/2008 Ander 1/7/2008
    1/29/2008 Ander 1/29/2008
    2/29/2008 Ander 2/29/2008
    3/1/2008 Ander 3/1/2008
    Barry 11/7/2007 Barry 11/7/2007
    11/14/2007 Barry 11/14/2007
    11/16/2007 Barry 11/16/2007
    12/4/2007 Barry 12/4/2007
    12/8/2007 Barry 12/8/2007
    12/27/2007 Barry 12/27/2007
    1/7/2008 Barry 1/7/2008
    1/29/2008 Barry 1/29/2008
    2/29/2008 Barry 2/29/2008
    3/1/2008 Barry 3/1/2008
    3/6/2008 Barry 3/6/2008
    Chico 11/5/2007 Chico 11/5/2007
    11/14/2007 Chico 11/14/2007
    11/16/2007 Chico 11/16/2007
    12/4/2007 Chico 12/4/2007
    12/8/2007 Chico 12/8/2007
    12/27/2007 Chico 12/27/2007
    1/7/2008 Chico 1/7/2008
    1/29/2008 Chico 1/29/2008
    2/29/2008 Chico 2/29/2008
    3/1/2008 Chico 3/1/2008
    3/4/2008 Chico 3/4/2008
    Delan 11/5/2007 Delan 11/5/2007
    11/14/2007 Delan 11/14/2007
    11/16/2007 Delan 11/16/2007
    12/6/2007 Delan 12/6/2007
    12/8/2007 Delan 12/8/2007
    12/21/2007 Delan 12/21/2007
    1/7/2008 Delan 1/7/2008
    1/24/2008 Delan 1/24/2008
    2/29/2008 Delan 2/29/2008
    3/1/2008 Delan 3/1/2008
    3/5/2008 Delan 3/5/2008




    I would like to autofill all empty rows in column a starting from the top all the way to the

    end of list with the next teams name. no team more than once. Teams Season starts in Nov or

    Dec and runs thru Feb to March. There may be a better way than autofill im not sure?
    Last edited by VBA Noob; 04-29-2009 at 02:20 PM.

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,607

    Re: autoFill rows in excel from given input

    I suggest you attach a small sample workbook illustrating what you want doing.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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