# roster

1. ### formula for roster (Indexmatch, and IF)

Hello, I am trying to make a small table that returns the name of the staff that works in today date based on a specific branch and shift. The range will be in the roster data. The result that I want is only the name of the specific staff that is working in that location and specific shift. If...
2. ### Leave roster with duplicate names and multiple date ranges

Hello forum - not sure what is possible so any assistance with the below question appreciated. I have 2 worksheets in a workbook: Sheet 1 is my raw data set and Sheet 2 is the leave roster I'm creating. Sheet 1 (raw data) has: Column D = names (duplicate names exist) Column F = Status (6...
3. ### Sort Employees in Roster

Hi so I need to do a roster for 9 shops in separate locations, and everyday there need to be 20 people working out of 42 employees. What I would like to do is for every shop I want to roster individuals that live closer to the shop, then if there is no one close to the shop I want another...
4. ### 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...
5. ### 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...
6. ### 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...
7. ### 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...
8. ### 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...
9. ### 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...
10. ### 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...
11. ### 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 =...
12. ### 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...
13. ### 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...
14. ### 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...
15. ### 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...
16. ### 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...
17. ### 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...
18. ### 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))...
19. ### 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...
20. ### 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...

### This Week's Hot Topics

Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
• Block certain cells in condition met in cell A
Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
• IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
Hi, Below formula works well, =(INDEX('PRICE LIST'!\$C\$7368:\$C\$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!\$A\$7368:\$A\$7679)*(WORKSHEET!P28='PRICE...
• Match data from 3 columns to return data from the correct 4th column
Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
• VLookup
Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
• Defining a range
Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back