employee

I have a list of employee ID's in column A. In column B is either YES or NO based on a vlookup verifying if they entered data in a schedule sheet. I need to send an email to any employee ID with a NO in column B. I would like to send them all in one email as a bcc since there are 180 employees...

Hello, First, I cannot use VBA for this; I need the spreadsheet to function within a sharepoint environment that doesn’t accept macro enabled worksheets. I am also very new to excel, but trying to progress rapidly. I am trying to create a single sheet within my dataset to return individual...

It is saying there are too many arguements, where should I add AND OR in order for this formula to work? =IF($D$1="","",VLOOKUP($D$1,'[Employment Contract (Causual Employee) HC_May20180903_D_SB.xlsx]Staff info summary'!$B:$DQ,91,FALSE)="","",'[Employment Contract (Causual Employee)...

<tbody> Employee Name Employee ID Position # Position Status Employee A 111111111 111111 A Employee A 111111111 777777 W Employee B 222222222 222222 A Employee C 333333333 333333 A Employee D 444444444 444444 W Employee D 444444444 555555 A </tbody> Hello there...

Hi, Can someone please help me with this: I have a database with the fallowing information for 200 employees: Employee Name, ID, Department, Position title, Performance rating, Base salary, Performance rating,%increase, Previous year salary . I need to create a tab for each employee with...

Hello, I have a problem with a formula in a staff holiday tracker. The tracker has the employees names in Coloumn A, from row 6 to row 15. Coloumns B-NI correspond to the days of the year: each employee enters the leave codes, as per the table below: <tbody> Leave Name Code Sick Leave S...

I am working on an employee attendance spreadsheet that is based on a point system. Point values are associated with different absence reasons and tracked on a rolling 12-month calendar. I was able to successfully complete a spreadsheet to take care of this part. However, I am unable to figure...

I have a questions I hope you can help with. I have an attendance time card in excel for a group of employees. I want to create on workbook where each employee can enter their attendance and a summary sheet to gather all their time so I can submit to payroll. I know how to create and map all of...

I have a workbook with a Labor/Equipment sheet. The sheet has dropdown menus for Employee, Title, Status (FT, PT, T) and Equipment. Labor costs are calculated based on work categories (A, B, C – G). Full time employee regular labor costs are not calculated for categories C – G. Part Time and...

So, I have a list exported from a system containing unique employee ids (children). Each of these rows has the employee’s manager unique id (parent). One of the employees is the CEO and is to be considered level = 1 I would like a way to calculate per employee what level they are on in the...

I'm building a fairly complicated spreadsheet that is going to be updated weekly. The spreadsheets name changes monthly so building a macro wouldn't be user friendly and I'm trying to build formulas with the workbook. The user imports data from another spreadsheet into "Week1". From there...

Hi All, New at VBA and requesting some assistance. I have the following task to complete. <tbody> <tbody> <tbody> Monday, 26 August 2019 </tbody> </tbody> <tbody> Monday, 26 August 2019 </tbody> <tbody> DEPART1 </tbody> <tbody> DEPART2 </tbody>...

Long shot on this but i really could use some help! I'm looking for a template or someone to help me build an employee directory. I'm not sure if excel is the right medium. Currently I have A Table of contents with names listed and linked to a tab with their info. Basically a self portrait and...

Hi... I'd like to ask if someone can help me to find the correct formula. I have an overtime tracking template for 31 days, the threshold total hours for the month is 303 for 30 days which is 10.1 per day, if an employee worked from 1-31, the threshold should retain 303, but if an employee...

Desired end result: A pivot table that counts employees onboard by month. The spreadsheet that I have is massive. It has over 10,000 employees and all the charge objects they could charge to in a day. So 1 employee will have multiple rows. What formula can I use to only count an employee...

HI, I have a cell(A2) with sql query select emp_name from employee where emp_Id=:empNo and emp_designation =:empDesignation empNo and empDesignation values will be taken from text box I need a help writing vb script code in extracting sql query from A2 cell followed by appending text box...

Hi all, I have used this forum to find answers for years and always found what I was looking for without even having to post my question. But this time I am stuck, proably because I don't knwo what exactly to search for. Let me explain what I am trying to achieve first: I am analysing employes...

Hi, I am trying to utilize a pivot table to sum up retroactive payments due to employees. This is taking place for about 2 months back and so obviously you will see multiple line items per employee. I want to just be able to copy and send the pivot table data up to the team that handles the...

Hello Everyone , I am trying to create an excel application for leave, I have got the template online and its perfect for me. I want to create a validation while applying leave and need your help for this. While applying for leave the system checks the employee column (Employee are divided...

Hello, I am looking for a code that will compare cells A2:A50 from "New Employee" sheet with cells A3:A1000000 in "Employee List" sheet and if a duplicate entry is found it will prompt a message box stating "duplicate entry found", highlight the duplicate and end the macro. I have a master...