employees

Okay, the title might suck, but I can't really think of a better one atm.. Little bit scatter brained trying to think of how to do what I'm looking for here.. lol. So what I'm trying to do, is build a weekly planner based off a list of employees. Each day, the employee gets a few notes...

Ok, so I am creating an attendance sheet. On one tab, I have a running list of employees that were tardy, left early, or absent and accrued points. On another tab, I have a roster of all the employee and I am wanting to create a different tab that list all employees with perfect attendance...

Hi All, I have a pivot table which contains a row of months with a column of employees. I have sorted the data with highest scores first, but don't know how to write a formula which returns with the top 5 highest/lowest employees per month. Also, as in the example below, there are blanks in...

I'm trying to create a dashboard that pulls from a different worksheet how many employees per manager are located in one of three regions. Here is what I have.... Worksheet 1 = HR EE Roster as of 04-05-18 has 37000 rows of employees (Column G has Country initials; Column L has Manager's Empl...

Hi, I am trying to find out what formula to use to add 6 months to a date that is found through an index match formula. It doesn't stop there though as there are some more criteria. In one tab of the spreadsheet called NEW BID, I have an employee number, name, seniority date, their schedule...

I have a pivot table that provides the data for individual employee reports. The employee's name is in cell A1 of each report, and it shows an amount by line of business. Each employee name is also an item in the pivot table. Lines of business are items in another pivot table field. Is there a...

Of the top 113 (out of 450) employees based on sales, I need to count the number of employees and sum their sales in each category. I have a list of 450 employee numbers along with their corresponding sales and assigned category. On another tab, ONLY for the top 113 employees I need to...

Hello everyone, Sorry I'm a total newbie to advanced excel offers and so I'm sorry if this is the wrong forum. I am starting work at a company and just got my schedule. The scheduler sends us a large monthly schedule listing what project (eg Facebook, Twitter) an employee is working on every...

Hey guys, I wonder if anyone can understand and also help me with the following. I use a userform to log user's (employees) start time by login with a 4 digit PIN into the application. If PIN don't match user will be prompted to try again or exit. This is to prevent employees from entering...

I currently use excel to track available sick and vacation time balances for employees. The basic information has been kept on a summary sheet in the workbook. I then have 52 weekly "reports" (work sheets) that track labor hours by type for individual employees per week. When an employee uses...

Hi Champs, I need some urgent help to sort out data for my organization. Basically, we have employees who go on official trips mostly for various client locations, seminars, courses etc. Here I need to find number of days employees spent under each seminar. The data looks like as mentioned...

Bear with me ... Excel scenarios never seem easy to describe. Part of my job is to collect data files from clients which are uploaded to our platform. One of the fields on the file template is reserved for the date clients would like a notification email to be sent. I'd like to have this...

I have a list of about 38,000 employees, and in that list is a column of who each employee's Manager is. I want to generate a list of all Managers and identify the employees under them. For example, if Susan Smith (manager) has four employees, I would want to generate a list the employees under...

Hi All I'm looking for a pointer where to start with this problem. I have two worksheets, sheet1 and sheet2. Sheet1 contains businesses whose credentials are correct. Column A has the businesses Ref No, Columns B-H contain the businesses name and contact details. Sheet2 contains the...

Hi guys, I have a spreadsheet I use as a template for employees to fill in. I would like to save the workbook after employees have entered details under their name located in cell M1 but not overide the current template. So they start by opening the spreadsheet template.xlsm. Enter their...

I'd like a punch-clock spreadsheet that uses a form control box to input employee # and order #, with time-in and time-out. Employees can clock on to multiple orders at once, and multiple employees can clock on to the same order.

Hi, I have a combobox1 to input or call the list of employee's ID number. What I need is: If I select/type one of the ID number of the list and ID number was found and I hit OK button then a word "resign" should add at column Q (column #1 7 ), right exactly at the row where the employee's ID...

We have a take home exam at work and I badly need help. This is for my application as an apprentice for a new post. I need to create exactly 24 schedule patterns for a 24/7 operations with 24 employees. There are certain rules that I need to follow: 1. I need to have a minimum of 6 employees...

Hello, I am trying to teach myself Access with the help of Google, but cant find what i am looking for, might just be searching incorrectly. I want to create a query , based on two tables, the first is Staff, the second is sales the common factor on both tables is their employee number. The...

Hi, I need to count the number of employees on a per hour interval. Employee shifts last for 9 hours. So if 2 employees will come in at 4 am and 1 will come in at 7, the result i want to get is like this... 0400 - 2 0500 - 2 0600 - 2 0700 - 3 0800 - 3 ....... 1200 - 3 1300 - 1...