Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
moving cells
I have a roster with 30 names on a fixed schedule for 15 weeks i want to move
the names through the schedule. Thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
moving cells
Hi Paul,
I would try an Excel web search on your Google toolbar or at http://www.google.com/advanced_search?hl=en for excel rotation OR rota schedule OR timesheets and a Google Groups search on a dropdown on your Google toolbar or at http://groups.google.com/grphp?hl=en&tab=wg&q= rotation OR rota schedule OR timesheets group:*excel* to get you started then ask specific questions if that does not provide enough information. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Paul" wrote in message ... I have a roster with 30 names on a fixed schedule for 15 weeks i want to move the names through the schedule. Thanks |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
moving cells
"Paul" wrote
I have a roster with 30 names on a fixed schedule for 15 weeks i want to move the names through the schedule. Just an option to tinker with .. Sample construct at: http://www.savefile.com/files/7312953 30 names 15 weeks rotation schedule_paul_newusers.xls In Sheet1, list the 30 names in A1:A30 Put in A31: =A1 Copy A31 down to A60 to repeat the name list Then in say, Sheet2, to create the schedule .. Put in A1: Week1, copy A1 across to O1 (this simply creates arbitrary labels for the 15 weeks in A1:O1) Put in A2: =OFFSET(INDIRECT("'Sheet1'!A"&ROW(A1)),COLUMN(A1)-1,) Copy A2 across to O2, fill down to O31 to populate the schedule -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
moving cells
Please note that the sample file was saved in manual calc mode
To check / change calculation mode back to "Automatic": Click Tools Options Calculation tab Check "Automatic" OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
moving cells
Thanks max
"Max" wrote: Please note that the sample file was saved in manual calc mode To check / change calculation mode back to "Automatic": Click Tools Options Calculation tab Check "Automatic" OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
moving cells
You're welcome, Paul
Thanks for posting back .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Paul" wrote in message ... Thanks max |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
30 Day Moving Average Ignoring Blank Cells | Excel Worksheet Functions | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
moving cells based certain value | New Users to Excel | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |