Excel AutoFill (Excel 2000)

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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.

Reply | Quote