Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Default build a name selector on a rota with the location showing against that persons name

Hi..

I am looking for someone to either show me or to do and show me the following please.. :-)

i have a shift pattern that has say for instance 50 locations some are multy manned some are single sites each most are manned with preminant staff others need temp staff all week some of the sites have a rotation of 1-4 weeks with that it could have 1-5 days off in it staff might need to have time off as well so where the gaps are i would like to be able to select from a list of people that are allowed to work there only to show and at the bottom there is a matrix with the person to the left and when you fill in the gap in the location above it shows below.....?
I have attached what i am working on

My Regards
Louis Eckersall
  #2   Report Post  
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by Task001 View Post
Hi..

I am looking for someone to either show me or to do and show me the following please.. :-)

i have a shift pattern that has say for instance 50 locations some are multy manned some are single sites each most are manned with preminant staff others need temp staff all week some of the sites have a rotation of 1-4 weeks with that it could have 1-5 days off in it staff might need to have time off as well so where the gaps are i would like to be able to select from a list of people that are allowed to work there only to show and at the bottom there is a matrix with the person to the left and when you fill in the gap in the location above it shows below.....?
I have attached what i am working on

My Regards
Louis Eckersall
Hi Louis,

There's no attachment...
  #3   Report Post  
Junior Member
 
Posts: 2
Default

Quote:
Originally Posted by Spencer101 View Post
Hi Louis,

There's no attachment...
sorry about that have cut the file down so only a few on there now
Attached Files
File Type: zip small_test.zip (12.0 KB, 44 views)
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
Number showing row location when you scroll Cimjet[_3_] Excel Programming 7 May 4th 11 05:57 PM
updating data location to build a VBA graph [email protected] Excel Programming 2 August 17th 06 04:49 PM
select a chart without the selector handles showing? Mark Stephens Charts and Charting in Excel 1 May 8th 05 07:00 PM
selector kwcarson Excel Worksheet Functions 0 February 13th 05 12:19 AM
How to build build a macro that automatically imports PedroPeso Excel Programming 1 December 26th 03 08:14 PM


All times are GMT +1. The time now is 05:28 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"