Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how do i set up a 'rolling shift pattern' worksheet?

Using Excel 2003, i want to be able to rotate a list, i.e - columns of
weeks/names/hours to be worked.
i want it to show, for example:-
week 36 and that corresponding name and hours to be worked.
then the following week it show week 37, name and hours, etc. at the top of
the page.

Can this be done automatically by excel or will i still have to keep doing
it manually?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a Worksheet zephyr Excel Discussion (Misc queries) 2 September 11th 06 07:25 AM
Excel: Relative worksheet references? Busy Beaver Excel Discussion (Misc queries) 2 September 10th 06 04:32 PM
Run-time error 1004: Cannot shift nonblank cells off the worksheet [email protected] Excel Discussion (Misc queries) 1 April 10th 06 06:13 PM
what should i use darryll Excel Worksheet Functions 3 March 6th 05 05:26 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM


All times are GMT +1. The time now is 11:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"