sequence

column A - num week(1 to 52), column B - day 20 to 21 next month.how can
create on column C, D, E, in sequential 1 on column C, 2 on column D and 3 on
column E for week 44. but chage in order in week 45 and all next in same
order.
C D E
1 2 3
2 3 1
3 1 2
continue in next weeks of next years.
tanks for replay!

Cesar,

I'm not at all sure what the 1 to 52 weeks, or the days 20 to 21 have to do
with anything. But to repeat the sequence you gave for C, D and E, select
the three cells. Drag the fill handle down, holding Ctrl.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"cesar" wrote in message
...
column A - num week(1 to 52), column B - day 20 to 21 next month.how can
create on column C, D, E, in sequential 1 on column C, 2 on column D and 3
on
column E for week 44. but chage in order in week 45 and all next in same
order.
C D E
1 2 3
2 3 1
3 1 2
continue in next weeks of next years.
tanks for replay!

layout of sheet: for this month: B7 - 21/Out/2006 to B37 - 20/Nov/2006, for
next month: B7 - 21/Nov/2006 to B37 - 20/Dec/2006, or next B7 - 21/Dec/2006
to B37 - 20/Jan/2007.
the date is changed only i chnge month in list box.
in auto in C9:C15 = 1 (23/Out/06 to 29/Out/06 = week 43) and D915 =2, and
E9:E15 = 3.
C D E
1 2 3 - week 43
2 3 1 - week 44
3 1 2 - week 45 ...
and all next weeks


"Earl Kiosterud" escreveu:

Cesar,

I'm not at all sure what the 1 to 52 weeks, or the days 20 to 21 have to do
with anything. But to repeat the sequence you gave for C, D and E, select
the three cells. Drag the fill handle down, holding Ctrl.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"cesar" wrote in message
...
column A - num week(1 to 52), column B - day 20 to 21 next month.how can
create on column C, D, E, in sequential 1 on column C, 2 on column D and 3
on
column E for week 44. but chage in order in week 45 and all next in same
order.
C D E
1 2 3
2 3 1
3 1 2
continue in next weeks of next years.
tanks for replay!

"cesar" escreveu:

column A - num week(1 to 52), column B - day 20 to 21 next month.how can
create on column C, D, E, in sequential 1 on column C, 2 on column D and 3 on
column E for week 44. but chage in order in week 45 and all next in same
order.
C D E
1 2 3
2 3 1
3 1 2
continue in next weeks of next years.
tanks for replay!