employee

I am adapting an old workbook for a new training program. I would like to rename each sheet by employee name but the way it is structured that format is not working. The cover sheet has a drop down to navigate to the employee page but it will not display the name unless i name the sheets 1,2,3...

Hello All, I have always appreciated the help that everyone has given here to other people and can usually find the answer that I'm looking for. You are all an amazing community. What I'm trying to do and I got most of it is find how many "occurrences" an employee has had within the past 30...

Hi to all of you, kindly require to provide me support for a VBA code so that, complete the month’s calendar dates in col. “C”, where an employee have no clock time records and thereafter to place in adjacent cell in col. “P” the letter “O” which it means that on that date he/she was day “OFF”...

Hi, Can someone please help me with this formula? I have this info: Column A = employee name Column B = hiring day Column C = Original vacation days per year (15 or 20) **Column D = Xtra vacation days Column E = Total vacation days (15+column D) For every year worked after 4 years...

Good Day excel Guru's! I am a novice with excel but highly addicted! My issue is this: I run a small business and I would like to track my payroll from several departments into an easy to analyze workbook. The trick is that ADP generates a weekly report in Excel format (which ill try to...

Afternoon all, I'm looking for a bit of help on the following. I've had a search through the forums but haven't been able to find what I'm after so I'm maybe looking for the wrong thing altogether. I would like to create some sort of custom calendar, using only formula from a list of data...

Hello, I am trying to create an Excel file that will scrub the output of a program I use (excel file output) into the format of the input I need for a different program. My issue arises when the output file will put the minutes of an employee into various columns of the same row based on...

Hi, I have below VB formulas and I need to turn each formula to value, can anyone advise how? Range("AA18:AA42").Formula = "=IFERROR(1-(AD18/AC18),IFERROR(1-(AD18/AC18)," & Chr(34) & Chr(34) & "))"Range("AB18:AB42").Formula = "=IFERROR(AD18/AC18,"""")" Range("Z18:Z42").FormulaR1C1 =...

Hello: (Please note I will add an example of the workbook tomorrow) if anyone feels they have an answer from my description, I’d be very grateful for a response: I have a workbook that is used as a calendar to manage a team of employees working across multiple contracts. The workbook...

I want to make a timecard calculator that tells you what time you need to clock out so an employee does not work over 40 hours in a week. Also the timecard displays time in a 100 minute clock. (Example) Employee worked 32.68 hours by Thursday, start time on Friday is 8:00am, lunch out is...

Hi, Can someone please help me with this: I have an excel file (A) with this columns: ID, employee, country I have a folder with 50 excel sheets. Each of these files has a summary workbook with this columns: ID, employee, country. I need a macro that allows me to fill in the summary tab of...

Hi, I have table that is dynamic and changes whenever I change the a value (Employee ID) in specific cell of a drop-down list. So when I change this ID then locations related to this ID should change, the issue I'm facing is that each Employee ID has different number of locations, some has 5...

Hi ive been working on a VBA project (Note: im still a novice and google everything I need to know) Ive developed a userform to capture some employee details and in the process to calculate the days to expiration of set dates against every new employee... The sting that I use are as follow...

I have this sheet created by H.R. System , you notice that the data of every employee are scattered at various rows . I can't use these data unless the code of every employee in the same column along with the value belongs to him then I can use pivot table to sum the values for every employee ...

In column A I have "Date" In Column B I have "Emp ID" In Column C I have "Percentage" In Column D I have "Trigger" Scenario: I want to mark employee with "Yes" in Column D if the same employee exceeded 100% total in the same date.

Private Sub empl_no2_afterupdate() If Not mbevents Then Exit Sub 'employee number error checking If Not empl_no2.Value Like "#####" Then MsgBox "Employee number has to be 5 numbers. a", , "ERROR" With empl_no2 .Text = "00000" .SetFocus...

Hello, this forum has been great. You all helped me with many functions including the VLOOKUP. However, I'm stump on one issue and I need some assistance as to what i'm doing wrong. I was able to get the VLOOKUP function to work perfectly. Now I want to add another VLOOKUP with the column index...

Here is the formula which I am using. Problem: Its not printing the correct row of data. =INDEX($A$1:$H$15,MATCH($A$18,$A$1:$A$15,0),MATCH(B$18,$B$2:$H$2,0),MATCH($A19,$A$3:$A$15,0)) Here is the same formula, which explains the above formula, and what I'm looking to achieve...

Hi All, I have a dilemma. At workplace we are updating to Win10 and I have to transfer some data from OneNote to Excel. We have employee files setup like navigation menu. I searched forum but I am not even sure what I am looking for. It would be much easier for me to make website and input...

I have two lists of employee names - one with names and phone numbers; the other with names and locations. The names in each list should match, but not necessarily. Some may have middle name or initial, or may have a hyphenated name. I want to use the "locations" list to search the "numbers"...