employee

I have a sheet of data, not in table form, more like a report with blocks of data that repeat themselves as you go down the page. I want to go through the data and extract some of the data and copy it to a different worksheet. I was thinking of using the Find function to locate where each...

I am trying to find Employee turnover by Year/Company I have and employee table and I have created a Calendar table The employee table has the following columns ID Hire Date Term Date Company Active Status I would like to createa dashboard to show by Company turnover % by Year (2018 &...

hello i am trying to write a formula to identify unique enterprise IDs associated with an employee. table below. i don't know where i am messing up, if somebody could advise. Column BH is where the formula is <tbody> Column E Column L Column BH Employee Officer Code Enterprise ID Unique...

I have a spreadsheet with employee information data, on a weekly basis I have to add data to the spreadsheet. I have a separate tab in same workbook that I create a pivot table based on employee information data. I update the pivot table on weekly basis with a simple refresh. The pivot...

Ive spent the last 2 hours almost searching and cant quite seem to find the right formula(s) to get what i want. I have a list of employee numbers (that are occurring more than once) and want two things from that list, the first being a separate column displaying the employee numbers without...

Hello, Looking for help creating a Macro to do the following: Sheet 1: Employee Info Sheet 2: Payment Prep In Sheet 1 we input the employee information and assign theman Employee Info Index Number I am looking for a Macro that will copy the data from theEmployee Info tab (which ranges from A2...

Hi Guys. Hoping someone can help me with this, I can’t seem to figure it out. Table Absence: Employee ID Date Reason Table RTW: Employee ID Absence start date Absence end date RTW completed date (There is other data, not relevant) If looking to match the absence to the RTW. Each absence...

Good afternoon, by racking my tiny brains on this one as to whether it is actually possible with such little knowledge I have, although a fast(ish) learner. I tried pivot tables but could only get on row of data to pull in. The data I have is employee payments and deductions by date listed down...

Sheet 1 has employee info Sheet 2 are blank employee cards Example is an example of where the info from sheet 1 goes onto sheet 2 If someone could create a macro to go through each case (all rows with data) on sheet 1 and have that copy to corresponding cards on sheet 2 that would be amazing...

I am working with an expense reimbursement report that takes into consideration several scenarios for mileage: 1. The first 30 miles driven of a total one-way trip are not reimbursed if the employee leaves from his/her residence. 2. If an employee leaves on a trip from the company storage...

Good evening friends, I am looking to build a digital version of the ancient manual logbooks currently used to track personnel entering/exiting our facility. I currently have badges with barcodes and scanners that capture personal information (Name, employee ID number, department), and use a...

Hi excel guru's just a newbie here, so I just need someone who can help me with a formula. Data is from column A to J, so what I need is like to appear a formula in J when 3 condition met. A=employee Id, start on row 3 and so forth, H= Date where employee process a case, I= marking if the...

I created a spreadsheet years ago to track employee hours, and now we need to add overtime to it. I'm hoping I can do this and have it calculate into one cell per employee. The spreadsheet is done monthly and I have just one sheet with everyone on it and then a sheet for each employee for...

Hello again, Earlier I asked for some help in extracting the last name of the employee in the string of characters listed below. The help was excellent and the formula below works perfectly. Now I've run up against another issue with this string. I now need to extract the 3 numbers to the...

Hello and thanks in advance for the help. Below is a string of characters and I need to extract the last name of the employee. The format will always be the same, there will always be 3 numbers to the left with a space between. I can extract everything to the left but my limited knowledge...

I am working on a utilization report that has a data model with 2 tables. Table 1 = Data (all hours worked by an employee), Table 2 = EmpCalc (standard hours base for an employee). My utilization measure is as follows: =sum(Data[Jan-19])/sum(EmpCalc[Jan]) I then created a Pivot which is has...

A program I use outputs data in a non-pivot friendly format. It has already grouped the data with different levels. I am trying to convert this data into data that is pivot table friendly. I currently have data like this where Location is always filled out and will have at least one (but...

I am NOT the greatest in Excel or VBA. In fact until the last week, I never used VBA, but am learning a lot from Forums and instructional videos. I appreciate everyone of you who participate in these forums and help out those of us who, at times, are utterly and completely lost! I need to...

I have racked my brain with a solution for this problem and can never seem to crack it. I have to calculate Cost Per Head (CPH) for several different slices of a data set consisting of >500k rows. This is simplified, but suppose my data has a column for Month, Team, State, Account, Account Type...

Hi guys, I'm a new member here but I've been using the forums for a while now and they've been a big help so far. I'm looking for some help with simplifying a training report I run on a regular basis. I first need to combine 3 reports with VLOOKUPs (or INDEX/MATCH) then I need to split them up...