how do I automatically sequence the month

R

Rubber 4 u

i want to just enter a month (text) in a cell, then have it automaticly enter
in sequence the following 4 months, there is info in 5 cells between each
month. how do i accomplish this
 
B

Bob Phillips

Just type say May in a cell, and drag and copy, it should automatically
update.

What does the second bit mean?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
B

Bob Phillips

Just thinking about it, if you wanted say Jan in a1, Feb in A6, then try

=TEXT("2007-"&INT(ROW(A1)/5)+1&"-01","mmm")

and copy to A6.

If you want to start at May, change A1 to A25 (month number * 5)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
H

Herbert Seidenberg

Assume your data in column A looks like this:
(4 data cells and 2 blanks)
A B
May
jnrc
hapj
odgq
nmek

June
gqck
qfde
qicn
rmbp

July
mrki
apbr
kqak
ibkc

In column B, type May, select it and 5 blank cells below it,
and drag down the fill handle as far as data in column A goes.
Select data in column A and
Go To > Special > Blanks
Delete > Shift cells left
 
Top