Thread: 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.

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.

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.