emp

Need a formula for the following: Sales goal 77% 300 points to spread amongst 4 employees based on results Emp #1 Actual - 83% Emp #2 Actual - 80% Emp #3 Actual - 78% Emp #4 Actual - 69%

Hello, I need help to update Main sheets from other Sheets Example Main Sheet <tbody> Emp ID Name Gross Salary Tax Net Salay </tbody> Sheet1(Jul-19) How will automatically Emp ID & Name updated in Main Sheet <tbody> Emp ID Name Gross Salary Tax Net Salary 01...

The title kind of states my goal. I am looking for some help to get started to solve the problem of scheduling a group of people based on demand and their individual constraints, using solver and VBA (or maybe a combo of the two?) Here is a picture to describe what I am looking for help to...

Good day to all. I have a table with multiple conditions with specific amounts if conditions are met, but Im stymied on how to create the IF and/or formula since the conditions have min/max ranges. Hoping for some help :( Thanks a lot! Sample table below: <style type="text/css"><!--td {border...

Hi All, I have a quick question regarding PowerPivot calculate column. I have below tables 1) Transactions <tbody> EMP ID EMP Name Sale Amount Sale Date Supervisor Name 1 xyz $1000 12/12/18 Sup 1 1 xyz $100 12/15/18 Sup2 </tbody> 2) HeadCount Table <tbody> EMP ID EMP NAme SUp Name...

I have been racking my brain and gotten stuck. I have a list of ids. Each id has the manager that incumbent report to. The list is from CEO down to bottom of org including every employee. (~46k rows) The list is in no particular order. What I would like to do is analyses on what level each...

Hope my title makes sense. So, I have a couple sheets of data. On one of the sheets is an employee Number, which I am using vLOOKUP to attach the name to that employee.. It is then SUMIFs, some data from another range based on that range (Employee Name). The problem is that a few employees...

Hi, Is it possible to apply countif formula from a closed workbook? I have one open excel workbook Data.xls which has emp id in cell A2 of sheet1. Another excel workbook name Conso.xls is in a shared drive folder which has emp ids in column B. I want to check how many times one emp id is there...

Hi Experts, I have a template which runs on macro. This template is used to prepare n save as file, where i have to manually enter Emp ID one by one and RUN the code to save file separately. Is thier a possibilty to load Emp ID from Sheet 1 (Column A of Database TABLE) to Sheet 2 (Column A2 of...

I have a sheet of daily manpower attendance. I need to prepare summary sheet with criteria of 1. Category (category to be listed in the summary sheet and mentioned in the attendance sheet) 2. Date (1 cell in summary sheet will be denoting date; so when I change this date, automatically the...

Hello Everyone, I'm trying to use the following formula: <code> =IF(P31=T31,"No-Affiliate bill code = Emp bill code",IF(P31<>T31,"Yes-See Column Q",IF(ISNA(VLOOKUP(K31,'Company Employee Codes'!$B$2:$B$198,1,FALSE)),"No-Account has the correct Emp bill code",0)))</code> The first two are...

Hi Experts, I have data like the table below, where I want to fetch time (Column C) when the Emp Code 843567 swiped his card on 05/23/2018 for first and last time between time interval 6:00 AM and 3:00 PM. <tbody> EMP Code DATE CARD SWIPE TIME 843567 05/23/2018 6:10 AM 674593 05/23/2018...

Hey Everyone, I have a rather large and probably complex sheet I am working on. It is(or will be) comprised of weekly schedule with a row for each hour of the day and column for each day. This will be a 24/7 schedule. The plan is for the schedule to automatically populate the names of by...

Hi everyone, I am having some issues with this marco, and full disclosure, I don't know much about macro's at all. But i am getting a runtime 424 error whenever i try to run this. The purpose is to pull from a list of employee numbers and print them on a safety inpection sheet. Any help is...

I think this would be a COUNTIF combined with a INDEX MATCH MATCH. -1 book -2 worksheets Input sheet from Call Report (this is counting attendance for conference call) <tbody> DATE PERSON ID 4-14 1 4-14 2 4-16 1 4-16 3 </tbody> What I want it to auto populate <tbody> Date Emp 1...

i have multiple employee with the same employee number in column A and a code in column b. how can I highlights the same value with duplicates in column B. Ex: Col A | Col B 1001 code1 1001 code2 1001 code3 1001 code1...

Dear All I am new to VBA. I have the below code which is a printing loop to a specific number specified in Cell A2. Sub PrintLeveCal()' ' PrintLeveCal Macro ' ' Emp = 1 Do While Emp <= Sheets("Invoice").Range("A2").Value Sheets("Invoice").Select Range("A1").Value = Emp...

Good morning I have a large data set approx 100,000 rows. I need to sum and combine the data based on Emp ID and DEPT only if they are the same. If the Emp ID and DEPT are not the same then leave it be. There will always be a Cur or Re in Column (S) The data must be Combined and summed in Cur...

Good morning, The way our planning system is set up, it creates a brand new record for an employee if they move departments. The first record will have an effective end date on the date of the transfer and the second record will have an effective start date on the same day. Normally, if they do...

Hello, I'm using a formula found on the internet for a call center Shift bid. It looks it should work I get a #NA message when you execute the formula. I'm getting a at #NA ISNUMBER(MATCH(B3:H3,I$2:I2,0)). The numbers in b2 represent a shift number. The goal is to find the first choice out...