Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Feb 2001
    Location
    Upstate, New York, USA
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel AutoFill (Excel 2000)

    I'd like to have a column with dates (format is M-YY, e.g., Jan-89) autofill, but I need each entry to appear 5 times due to changing values in the next column. Jan-89 should appear in the first 5 rows, then Feb-89 in the next 5, and so on.

    Any ideas? Thanks in advance for any help.

  2. #2
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel AutoFill (Excel 2000)

    Not sure what you mean by autofill, but here's a quick way to get what you need, and it's easily expandable as you add more rows.

    Type 1/31/89 in cell A1. In cell A2, type =A1. Copy this down the column 3 more times. In cell A6, type =eomonth(A1,1). Format all 6 cells as M-YY. Now just drag cell A6 down the column as many times as you need.

  3. #3
    Lounger
    Join Date
    Feb 2001
    Location
    Upstate, New York, USA
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel AutoFill (Excel 2000)

    Beautiful! This is exactly what I was looking for. Thanks so much for the quick response.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •