employees

Hi all, I have an interesting issue I have been searching far and wide for a solution to no avail. I have 3 employees who are assigned tasks every week. They rotate tasks every week. There are about 30 tasks, but they change every week so one week tasks A, J L K need to be assigned and the next...

Hi there! Please help :) I have a graph with salary range and I want to plot my employees as dots on a bar per grades accordingly. I think I did all right, but my dots (employees) appear on a right side of the graph and not on the bars ( salary range). Both Employees and salary range are primary...

Hello everyone, I'm assuming this is the ideal function, but I could be way off. Issue on "data" page: Need name of employee (column E) to register a "Division" (e.g. Administrative, Maintenance, Shipping, Production) in another Cell (column W) On "Employees" page I have a the four "division"...

I tried the formula below =ROUNDUP(RANK($C27,Rando)/Sizes,0) and it works great for a list of people. I need this formula to work for a group of employees rather than a list of names. My chart below shows a group of employees in each department. So 42 represents one department, 19 another group...

I have a list of managers (column A), a list of departments that are assigned to these managers (the amount varies) (column B), the final column contains the amount/values of employees in each dept (column C). The purpose of the list is to distribute it to 6 different people. I need 6 different...

Hey all, I've got this list of Employee ID - Employee Name - MGR ID - Manager Name. 1400 employees, ~400 managers. I'm looking for a formula or function or feature - SOMETHING that will allow me to populate the Manager ID. I know VLOOKUP would work if it was a 1:1 relationship but as the...

Trying to write a sheet to track employee pay for about 10 employees. I can figure out the hours worked easily enough. What is the simplest way to figue the employee share of fed and state taxes? All of our employees will earn less than 100k per year, but may have different with holding numbers...

Question: How many employees were promoted more than 7 months ago (Column C)? If they were not promoted, then how many employees were hired more than 7 months ago (Column B)? <tbody> Employee Hire Date Last Promotion Date Employee 1 <tbody> 09/12/2013 </tbody> 01/01/2018 Employee 2...

I searched for a similar situation to mine and didn't see one (apologies if one exists and I missed it!) I have to format a long list of managers and their employees for mass emails, and the lists I get from our database are: <tbody> Manager 1 Employee A Manager 2 Employee B Manager 2...

Hi All, Noob Here :) seeking help in auto tracking of employee's earned Compulsory Time off based on an employee's schedule.

Hello everybody, I am currently trying to determine from the data model, how high the absence rate for the individual weeks or months. So far, I've just added the factor to the pivot calendar, whether it's a workday. The table with the presence or absence of the employees is structured as...

Hi all, I'm extremely new to VBA and need assistance. I have 2 worksheets; Worksheet 1 has is a list of all employees in both department "A" & "B". Worksheet 2 is a list of employees from department "A" & their tasks for the day. I would like to create a VBA where I can enter all of my...

Hello All, If anyone can you assist I would be greatly appreciate it. Ex.: I have a list of 10 Employees that do various jobs. Of those 10 employees, 3 employees cover the job of the person(s) on Vacation. The maximum number employees on vacations is 3. I would like to show (in a excel...

Is there a way to set a filters criteria based on a list of variables? I have a master list of names of all employees. Some employees get reassigned to new areas on a regular basis. I get schedule updates from their supervisors each week. The list of employees by each area changes. What I'd...

<tbody> NAME LINE SUN MON TUE WED THUR FRI SAT LEE 1 4:30 13:00 4:30 13:00 4:30 13:00 4:30 13:00 4:30 13:00 OFF OFF OFF OFF JOHN 2 4:45 13:15 4:15 12:45 4:15 12:45 4:15 12:45 4:15 12:45 OFF OFF OFF OFF JAMES 3 6:45 15:15 6:45 15:15 6:45 15:15 6:45 15:15 6:45 15:15 OFF OFF OFF OFF...

Hey all! I have a very long list of employees in which I need to extract their names into a consistent format. I'm using the below formulas with a 99% success rate, however employees with a suffix of "JR" or "II" (etc) are throwing a monkey wrench in the calculation. First...

Greetings! I have produced a query that shows only the names of employees who have not logged in. But, I want the query to also only give me the employees who have not logged in for the current date = Date(). How do I incorporate that into this query I have already produced : SELECT * FROM...

Hi There, I have a file template with a series of identical tabs containing tables as individual timesheets for various employees. I make one new file each week. Each employee has their own tab and different weeks we may have a new/different mix of employees. I need to take all the tabs that...

Hi all! I have come here several times in the past to find excellent help with my spreadsheets but I am thinking that I may be looking for something beyond the scope of Excel. I have been asked to take over my department scheduling and I am looking for a solution that will replace the current...

Why am I getting the following Error Message on the Below codes. Run-time error '424': "Object required" Public Sub NewIT() Dim Employees As ListObject Set Employees = ThisWorkbook.Sheets("Employees").ListObjects("Employees") Call ThisWorkbook.Worksheets.Add(After:=Employees.Parent...