Page 3 of 3 FirstFirst 1 2 3
Results 21 to 24 of 24

Thread: Worksheet named from cell

  1. #21
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,938
    Articles
    0
    Excel Version
    O365


    Register for a FREE account, and/
    or Log in to avoid these ads!

    What to show in the To Cover cells Andy?

  2. #22
    Acolyte AndyDuncombe's Avatar
    Join Date
    May 2016
    Posts
    24
    Articles
    0
    Excel Version
    365
    They should also be data validation calls from SHIFT DETAILS worksheet. All shifts to be displayable for all rosters. The magic you're weaving with this spreadsheet astounds me, but I need to be able to add to theses shifts as and when necessary. My understanding of the DV functionality is that if I insert a data value somewhere between the first and last this will show in the drop down

  3. #23
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,938
    Articles
    0
    Excel Version
    O365
    Andy, I am not sure I fully understand that, so let me state it as I see it.

    You want the 'To Cover' items to have DV, that was expected, but what list should be in that DV? Will it be the same people for that site, everyone else, or some other list?

    As to the DV functionality, it will only appear in the list if you put a new team member in the right place. So, if Bournemouth gets a new person, you need to add the person to the staff table, in a row where the other Bournemouth team are, and add the site id (you do not need the fullname, formula derived). You should insert the new person in place so that the team appear in the order you want. You cannot just add it at the end, the team need to be together. Do that, and that person will appear in the DV for Bournemouth- I just tried it and it works .

  4. #24
    Acolyte AndyDuncombe's Avatar
    Join Date
    May 2016
    Posts
    24
    Articles
    0
    Excel Version
    365
    Hi Bob, we seem to have gone away quite extensivley from my primary objective which was to name each sheet dynamically from a list.
    Click image for larger version. 

Name:	XL GURU.jpg 
Views:	4 
Size:	68.6 KB 
ID:	10835
    Whilst I appreciate your expertise and efforts I'm trying to develop my skills too

Page 3 of 3 FirstFirst 1 2 3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •