Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying the same information every week in different cells and preserving data. | Excel Worksheet Functions | |||
group sales by week and week number | Excel Discussion (Misc queries) | |||
Day of week concacted from three cells | Excel Discussion (Misc queries) | |||
How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) |