+ Reply to Thread
Results 1 to 13 of 13

Roster Issue

  1. #1
    Registered User
    Join Date
    05-07-2016
    Location
    Australia
    MS-Off Ver
    365
    Posts
    6

    Talking Roster Issue

    Hi All

    I have been trying to create a roster that self populates horizontaly and highlights any overlap and also tracks positions.

    The inputs are the start date, days on & days off. Id like to colour the different positions.

    Roster.JPG

    If anyone can help it would be greatly appreciated

    Cheers

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Roster Issue

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    05-07-2016
    Location
    Australia
    MS-Off Ver
    365
    Posts
    6
    Quote Originally Posted by Raegan2016 View Post
    Hi All

    I have been trying to create a roster that self populates horizontaly and highlights any overlap and also tracks positions.

    The inputs are the start date, days on & days off. Id like to colour the different positions.

    Attachment 459478

    If anyone can help it would be greatly appreciated

    Cheers
    Is anyone able to assist. ???????

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Roster Issue

    If you post a sample workbook, I'll try to help you and so may some others

  5. #5
    Registered User
    Join Date
    05-07-2016
    Location
    Australia
    MS-Off Ver
    365
    Posts
    6

    Post Re: Roster Issue

    Sorry guys, I'm new to the format

    http://www.excelforum.com/attachment...1&d=1463296869
    Attached Files Attached Files

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Roster Issue

    Hi Raegan,

    Try this:

    Please Login or Register  to view this content.
    Directions for running the routine(s) just supplied

    If you haven't used macros before you'll need to go to:
    File- options - trust center -trust center settings - macro settings ,
    the second option down (disable all macros with notification)

    Then - Copy the code to the clipboard

    Open your Workbook

    Press ALT + F11 to open the Visual Basic Editor.

    Select "Module" from the Insert menu

    Type "Option Explicit" then paste the code under it

    With the cursor between Sub and End Sub press F5 (F8 to Single Step)

    OR

    Press ALT + Q to close the code window.

    Press ALT + F8 then double click on the macro name
    *Be sure to save the book with the code as Macro-Enabled

  7. #7
    Registered User
    Join Date
    05-07-2016
    Location
    Australia
    MS-Off Ver
    365
    Posts
    6

    Post Re: Roster Issue

    Hi

    thanks for that but i have somehow caused in issue whilst trying to introduce some additional functions.

    I want to add a count function adding personal per day and also seperate the positions to allow for constant onsite supervision and an L3

    Any help would be appreciated.

    Cheers
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    05-07-2016
    Location
    Australia
    MS-Off Ver
    365
    Posts
    6

    Re: Roster Issue

    anyone out there??? please help me out, it would make my life a lot easier at the moment??

    thanks

  9. #9
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Roster Issue

    Hi Raegan,

    To do what you're asking, I'd need more explanation - some examples would be even better

  10. #10
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Roster Issue

    This will at least take care of the unanticipated Days On = 0:

    Please Login or Register  to view this content.

  11. #11
    Registered User
    Join Date
    05-07-2016
    Location
    Australia
    MS-Off Ver
    365
    Posts
    6

    Re: Roster Issue

    I need the rostered days on to link to the title. as attached.
    Attached Images Attached Images

  12. #12
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Roster Issue

    This works

    Please Login or Register  to view this content.

  13. #13
    Registered User
    Join Date
    05-28-2016
    Location
    Atlanta, GA
    MS-Off Ver
    office 365
    Posts
    1

    Re: Roster Issue

    Hi I have a column that includes positive and some of the positive have matching negative numbers I like to search for the pairs of positive and negative and write the pairs first then the rest of the numbers. Here is an example
    1
    2
    3
    4
    5
    -1
    -2

    after sorting the column should look like this:
    1
    -1
    2
    -2
    3
    4
    5

    I appreciate your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Roster 4 ON 4 OFF
    By Godzilla65 in forum Excel General
    Replies: 1
    Last Post: 07-05-2012, 12:09 AM
  2. Excel 2007 : Help with formula issue for work roster
    By Mittay in forum Excel General
    Replies: 0
    Last Post: 09-26-2011, 01:48 AM
  3. roster
    By octopi in forum Excel General
    Replies: 1
    Last Post: 09-18-2010, 11:40 AM
  4. roster
    By Squallr in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-24-2010, 11:44 AM
  5. Roster
    By sprinter1801 in forum Excel General
    Replies: 11
    Last Post: 05-29-2010, 01:50 PM
  6. roster
    By Greg Brow in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-10-2005, 03:06 AM
  7. Roster
    By Greg Brow in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 02-10-2005, 01:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1