Thread: Cells by Week
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Willing to learn Willing to learn is offline
external usenet poster
 
Posts: 18
Default Cells by Week

Hi,
I am doing a schedule. I have two worksheets, one is by month, and the
another one by week.

The one that is by month, it was easy to do the setup. I just type in cell
A1 August and then in B1 September and from there, I select those two cells
and I drag the selection of those two cells to the right and it started
giving me what I want. October November and so on.

In the other hand, in the week worksheet, it started to be complicated.
I would like to starting having at A1 the following;
August 2007 week 1 and at B1 August 2007 week 2and then at C1 August 2007
Week 3 and then at D1 August 2007 Week 4 and then at E1 September 2007 Week 1
and so on.

Is there a good way to do it as the months woorksheet? I would like to just
select those cells A1:C1 and then drag it up to December 2010.
Otherwise, it will take a lot of time doing it up to December 2010

Please advice,
Regards