roster

  1. Phil Smith

    Use VBA to find which row on another worksheet contains a given value

    Hello Excel People! In column A on one worksheet, "Base Roster", I have a column of numbers, in order from 1 to 70. In Column A on another worksheet, "My Roster", I also have a column of numbers, but they are not in ascending order. As my code loops through and fills in worksheet "Base...
  2. Skrej

    finding first MWF of week

    I'm trying to figure out a formula for an attendance roster that will calculate the first M/W/F of a month. Since this particular class only meets M/W/F, I'd like to generate an attendance roster that for each month (each month on separate sheet) which finds the first day of the month that's...
  3. D

    Help with IF Formula

    Hi All, Noob here :) Need help with IF function. I have Data from Cell A2 - K2 Cell's B2 to K2 displayes "Yes" or "No" it compares previous week roster to current week roster I wan't to display Data in A2 using IF if there was changes from previous week to current week. I was thinking of...
  4. M

    Coloured Cells/Contents

    Hi Guys, bit a headscratcher, I have a roster that im trying to calculate. The roster has several employees, each with there own colour and how many hours they have, eg, A1, A2 and A3 are Green and have 1 in each cell. So lets say Alan, who is "green" will have a total of 3. Is there a...
  5. D

    Excel - Getting a Roster to highlight/identify gaps in a 24/7 roster

    I have looked through some of the other questions on here and can't seem to find the answer so hope someone can help me, there is probably a simple fix to my issue and I am showing my limited knowledge regarding the functionality of excel. I have a 24/7 roster that I would like to automatically...
  6. P

    Creating a randomly populated roster from a list

    Hi all, I am a new user to Excel and would like to create a roster for work. I am a teacher and I need to allocate staff to Areas around the school for supervision. I have attached the roster outline with some random names and criteria for the roster. I feel that with some guidance in the right...
  7. T

    Copy Data from One Sheet to Another Based on Date Chosen

    Posted to ExcelGuru: https://www.excelguru.ca/forums/showthread.php?9998-Copy-Data-from-One-Sheet-to-Another-Based-on-Date-Chosen In my file, I have a sheet that contains the entire roster over many months [and years] - called Full Roster To make it easier for the user to locate the required...
  8. B

    Rolling Monthly Roster linked to In or Out Occupancy

    Hi, I wonder if anyone can kindly help us on this issue? We have a Monthly Camp Roster Sheet, [R] = resident in camp / [Out] = resident left / and [In] = resident returned. However, our second sheet (the one we need linked), is occupancy in the room, which shows; 1 = resident in / or 0 =...
  9. R

    VLookup Help

    Hello to all. I am trying to compile information from a results spreadsheet to a roster spreadsheet. My issue is that there are multiple lines of data on the results spreadsheet, and the roster only lists the member one time. How do I get a vlookup to return all the information from the...
  10. B

    Question on Filling Out Fantasy Roster

    Hello, I'm trying to build a fantasy baseball spreadsheet. I have a list of players that I'm hoping to fill in each roster spot for each team. The player's name is in Column B. The player's position is in Column C. On the same tab, I'd like to place each player into a roster spot which is...
  11. E

    Excel Shift Work Roster Exporting to Google Calendar (or similiar)

    Good evening, I manage a nursing shift roster for about 160 odd staff. I use excel to build and publish the roster and am currently looking at trying to export to a google calendar (or similiar). We use text code for the shifts (i.e. E = 0715-1545 & LM = 1445-2315). Currently the shifts are...
  12. U

    Populating a ListBox with Filtered data

    I’m attempting to display only the Active Members in my database (Sheet11). This code populates ListBox1 with the entire database Range (C2:C). How can I modify the code to show only the Filtered Range? Private Sub CommandButton4_Click() If CommandButton4.Caption = "View Active Roster" Then...
  13. Ramballah

    Import information from my Roster

    Hello folks, I will be starting my next college semester next week and so I get a Roster every week. This roster is online on a webpage. I have an okay understanding of excel and VBA and I know that with somethings excel can import the information from a webpage to excel. Which I am looking for...
  14. A

    Roster spreadsheet using v/h lookup, sumproduct.sumif....??

    Hi Forum I am trying to simplify a roster spreadsheet for payroll. Sheet 1 Roster - job, staff and days working <tbody> Job shift hours mon tue wed thur fri job 1 0930-1800 sally bill tom bob sally job 2 0730-1600 bill sally bob pete bob job 3 0800-1630 tom bob sally tom pete job...
  15. C

    Object defined error?

    Hi there, I'm baffled by a seemingly trivial problem in VBA, maybe I didn't define something? I was hoping ya'll can help shed light on this. :) Basically, this code works: Dim roster As Worksheet With ThisWorkbook Set roster = .Sheets.Add(After:=.Sheets(.Sheets.Count))...
  16. W

    Roster help

    I am creating a roster for work with some colleagues and trying to find a simple way to run a report. The roster already shows how many people on each shift via a counter. It is a large sheet dates from B9-B374 and names for staff T6 - DY6. What I need is a simple way where you could enter...
  17. M

    Copy Only New/Different Items to a List

    I use this macro to take an active roster of people and some data about them, and transfer portions of it to a secondary roster. Unique to the secondary roster is that no one should ever be deleted from the secondary roster. The primary roster is active in the sense that people are constantly...
  18. D

    Calender / Roster Help please

    Hi All Need some help please. We are working on 28 day roster. With some off days in between. Then the cycle starts again. It looks like this <tbody> Th Fr Sa Su Mo Tu We Th Fr Sa Su Mo Tu We Th Fr Sa Su Mo Tu We Th Fr Sa Su Mo Tu We T N N N X D D D X X X N N X X D D D D X N N X X X X X X...
  19. I

    Subtract lunch hours

    Currently i have a roster done where it has start times and finish times for each day and the formula adds up the hours for the week. What i want to do is have a formula that will add the hours together but then subtract the lunch hours or if under a certain amount of hours each day subtract 30mins.
  20. E

    Combining two workbooks together

    Hello all, First and foremost I am not a excel wiz and just beginning. Background info: I recently have taken over an operations position of a militaryschool and I am trying to clean up the way some data is stored and presented. Currently I have been able to research and consolidate mostof the...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top