Thread: [Solved] Formula to fill in sequence
View Single Post
 
Old 04-16-2021, 12:30 AM
14spar15 14spar15 is offline Windows 7 64bit Office 2010 64bit
Competent Performer
  
Join Date: Mar 2011
Posts: 100
14spar15 is on a distinguished road
Default Formula to fill in sequence
Hello, I’m looking for a formula (or vba) to fill in a range of years. For example if A1 is 1995-2004 then B1 would be 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004. If A2 is 1968-1972 then B2 would be 1968 1969 1970 1971 1972. Thanks
Attached Files
File Type: xlsm Book1.xlsm (9.7 KB, 14 views)
Reply With Quote