+ Reply to Thread
Results 1 to 4 of 4

Filling in Model Years Between Two Year Brakes

  1. #1
    Registered User
    Join Date
    01-24-2012
    Location
    Vancouver
    MS-Off Ver
    Excel
    Posts
    2

    Filling in Model Years Between Two Year Brakes

    Hello, I am trying to build part lists for vehicle models and I have beginning and ending years for the models
    They are all Each Value is in a seperate cell

    Examples
    1987 1996 Jeep Wrangler
    1997 2002 Jeep Wrangler
    2003 2006 Jeep Wrangler
    2007 2012 Jeep Wrangler

    What I would like to show up is
    Jeep Wrangler 1987,1988,1989,1990,1991,1992,1993,1994,1995,1996
    Jeep Wrangler 1997,1998,1999,2000,2001,2002
    Jeep Wrangler 2003,2004,2005,2006
    Jeep Wrangler 2007,2008,2009,2010,2011,2012

    I would like to now have to type all the years between the beginning and end date.

    Any help would be greatly appreciated.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Filling in Model Years Between Two Year Brakes

    Hi
    should all resulting values be in the same cell or in adjacent ones?

  3. #3
    Registered User
    Join Date
    01-24-2012
    Location
    Vancouver
    MS-Off Ver
    Excel
    Posts
    2

    Re: Filling in Model Years Between Two Year Brakes

    Sorry,
    I would like the information to be in the same cell, if it were easier to get the results into adjacent cells that would be ok too as I can just combine those after.

    Thanks for taking the time to look at this.

  4. #4
    Registered User
    Join Date
    01-26-2012
    Location
    Bangladesh
    MS-Off Ver
    Excel 2007
    Posts
    1

    Post Re: Filling in Model Years Between Two Year Brakes

    Hi,

    For filling the years between 1987 and 1996, first type 1987 and 1988 in adjacent cells. Then select both cells, there will be a plus sign, if u put the mouse in the right corner of these selected cells. Then by clicking the plus sign drag ur mouse pointer until u get 1996.

    This will only work in adjacent cells.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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