Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I am looking for some help in solving an issue i have with a shift rosta. I have 17 rows in excel whick relate to 17 shift persons Cell A1 to A17 as follows A B C D E F G H I J K L M N O P Q What I am looking for is for on every thursday I need data in cell A17 to be input into cell A1 and all the other cells to go down 1 cell, e.g. data from cell A1 to Cell A2 and so on, this is the data I need to rotate no other data needs to rotate. Can anyone give me some help on this. Many thanks terilad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change the display data format cell already contain data as date | Excel Discussion (Misc queries) | |||
change cell data without leaving cell? | Excel Discussion (Misc queries) | |||
change cell colour when cell data changes | Excel Discussion (Misc queries) | |||
Change color of cell when different cell has data entered | Excel Discussion (Misc queries) | |||
How do I change cell color based upon data range within the cell? | Excel Worksheet Functions |