Show Latest Information For Employees
Mar 27, 2008
I have an excel file with 2 tabs. tab 1: Active and Tab2: tenure. Tabe 1 has the following column headers
Manager
Employee Name
Dept
Assignment
Original Start Date
End Date
Bill Rate
The Employee names may be repeating in this tab becasue whenever the employee is extended for a new assignment he has a new start date and new end date and new assignemtn and rates....This helps track the historical information about the employees. TAB2: (tenure) also has the following column headers...................
View 4 Replies
ADVERTISEMENT
Mar 26, 2014
I would like to generate a dynamic list of employees on sheets based on information on Sheet A. Here is my workbook structure:
-Sheet A contains all employees information (Name, division, salary hire date, etc)
-Sheet B is named Div A
-Sheet C is named Div B
-Etc...
Here is what I want to happen:
-Sheets B should pull the employees name and salary from sheet A only for employees of division A
-Sheet C should pull the employees name and salary from sheet A only for employees of division B
-Etc..
Sheet B, C , etc. should update the info and resort every time sheet A is updated.
View 5 Replies
View Related
Dec 1, 2012
I have aworkbook with Employee details data sheet. And, I have built two userforms to search and view the employee’s full details. I don’t know how to link the rowsource for combobox and textbox.
I have attached the excel file of what I'm trying to accomplish.
Book2.xlsm
View 9 Replies
View Related
Nov 19, 2009
I have an excel sheet with over 4,000 rows of records regarding our 80+ employees clocking in. There are three columns:
A: Date (MM/DD/YYYY)
B: Time (HH:MM:SS)
C: Employee Name
Our employees are expected to be at work (and clock-in) at or before 8am.
At first, I just filtered the data to display only rows that have a time value of between 8am and 9am (the hour when most people are tardy). However, I now realize this is not a very accurate way of reporting tardiness.
Our forklift driver, for example, almost always arrives at 7:45am, but then works around the entrance and has to scan his card (clock-in) several times throughout the morning to get back into the building. So if he's moving something outside and comes BACK inside at 8:30am, my current "filter" inaccurately reports him as tardy for that day.
Is there some way to filter this data to first reduce it down to their earliest clock-in for the day, THEN isolate only the 8am - 9am data (if we did that, the forklift driver problem would be solved because his only time for that day would be 7:45am - his TRUE clock-in). The forklift driver is just one example. Many other employees occasionally go in/out of that door and end up clocking in multiple times, so are getting wrongly reported as tardy.
View 9 Replies
View Related
Jan 6, 2009
Having problems with the following:
First Column Second Column Cumulative (B-A)
1 10 9
2 20 27
3 30 54
4 40 90
Every day,a new row is added and i want a formula at the top of the sheet to show the latest figure in column C.
View 2 Replies
View Related
Apr 10, 2014
If I have data that shows one year back information, how do I get my chart to have the last date showing up on the axis (the date label) to always be the most current date?
View 4 Replies
View Related
May 12, 2009
I am having trouble getting my search information to show under the column headings in the listbox. My search reference is column E and I want to show the information for column F, I and A of the same row as the search match. Here is my code and a copy of the file I am using.
View 2 Replies
View Related
May 2, 2008
To minimize the amount of time I spend building reports each day I consistently reuse existing pivot tables for my daily reporting by deleting the data a pivot table is based on and inserting new data. When I refresh the pivot table the new information is shown.
However, I have noticed that the drop down filters in all my pivot tables are showing selections that existed in previous data but are not in the current set of data.
Is there a way to update the pivot so that the drop down filters only show selections that are pertinent to the current set of data?
View 9 Replies
View Related
Apr 29, 2009
=IF((C13>E13)*AND(B15>D15),0,1)*OR((E13>C13)*AND(D15>B15),0,1)
This function seems to work well, however there is one thing I want to add to it somehow, and I can't seem to make it work. I want the cell to show a zero if there is no information in cells C13 and/or E13.
View 9 Replies
View Related
Mar 12, 2012
I have a Sheet1 that contains 900 rows of information 14 columns wide (C7:P7 are headers). Column M has an important date. The information is constantly changing.
On Sheet2, I want to display the upcoming dates, in numerical order for each row that's within 5 days of today's date. After the date has passed, it no longer needs to display on Sheet2.
View 1 Replies
View Related
Nov 24, 2008
when I reference the information in worksheet 1 with worksheet 2, and I have no info in worksheet 1, I get zeros in worksheet 2. is there a way to have the cell show up empty until there is information worksheet 1?
View 9 Replies
View Related
Jan 27, 2010
I need to show an information box e.g. "Initialising..." that I can show and remove without user interaction. I can't seem to find this using either a userform or msgbox.
View 5 Replies
View Related
Feb 11, 2010
I have created a userform that allows input of information and then deposits the information on a specific sheet. I am looking for a way to have that information not only deposited on the specific sheet it is already set to but also to another sheet based on a selection made from a combo box.
here is my current
View 5 Replies
View Related
May 19, 2014
I been working on excel sheet that will distribute 200 items between the employees that are available to work. I've attached a copy of the workbook. First I need to look at the quantity of employees I have working that day. Second Distribute the items to each one of the employees. Third give the first employee the first piece. Fourth give the next available piece to the last person with a zero piece in their list.
book8.zip
View 12 Replies
View Related
Sep 19, 2008
How can I protect by workbook from ex-employees and the competition from using (I am aware of the weak security measures Excel offers, but something is better than nothing)? Each worksheet is password protected to slow down novice Excel users. However, ex-employees know the password. I was thinking if there was a way to have a changing password (which only a couple people would know) or have the worksheet look for a hidden file on our network, that one of these methods (or another) might work.
View 6 Replies
View Related
Apr 17, 2009
I am creating a employee time sheet.
I am doing calculation.
I used total hours formula is =(I5-B5+(I5<B5))*24
and also worked hours formula is =((I5-B5-(I5<B5))-(D5-C5+(D5<C5))-(F5-E5+(F5<E5))-(H5-G5+(H5<G5)))*24
Problem is don't show the correct time of total hrs & worked hrs
Here i am attaching my timesheet format.
View 14 Replies
View Related
Jan 11, 2013
I am trying to get a count of supervisors and employees at any given time during a few day span. I think maybe a pivot chart might work but I'm stuck.
In my example I have a number of supervisors and employees in separate groups. I would like to type in two dates and two times for an in between time and get the total amount of employees working during a certain time.
Count of Employees at any given time.xlsx
View 6 Replies
View Related
Dec 9, 2013
After much searching today I've been unable to find a way to do this. All my searches resulted in some generic looking site looking to sell me some scheduling software.
I have a team of 7 people and I need one person to work a late shift each day of the business week. M-F
I would like a way to have the schedule automatically advance to the next person.
View 1 Replies
View Related
Sep 25, 2013
I am a part of an construction company, I am looking to calculate Rig Pay, Truck pay and Perdiem for each employee based on an Excel Spreadsheet pulled from the Time Card Lines out of our accounting software. I am struggling terribly, and need assistance. The Calculations are as follows
Every Employee has multiple lines in the Time Cards sheet.
Rig Pay, Truck Pay, and Perdiem come from the Employee file in our system
If employee id is the same, job number is the same, cost code is the same, calc rig pay * hrs
If employee id is the same, job number is the same, cost code is the same, calc truck pay * hrs
If employee id is the same, job number is the same,Data, and cost code is the same, calc Perdiem /day
The final result i should see how much each employee charges rig pay, truck pay, and perdiem per job, and cost code.
View 9 Replies
View Related
Apr 22, 2014
I have a list of employees and the dates they worked. I'm trying to formulate an IF function that will check the name of employees in the list against the to the contents of a particular cell and also check the date the employees worked against another cell that contains a specific date, and if both these conditions are met, mark that cell with an X, if not leave it empty.
The formula I have right now is =IF(AND(A2:A27=G4, D2:D27,H3),"X",""). A2:A27 is the range that contains employee names, G4 is the first employee's name who I want to check if he is on the list, D2:D27 is the list of days they worked on and H3 is the date I want to know if this particular employee worked in. Using this formula returns either an empty cell of a #NAME? error. Is this a cell formatting issue?
View 14 Replies
View Related
Nov 28, 2013
I am attempting to create a rotating weekend work schedule in Excel to make life easier. There are 30 people who rotate Saturday's and Sunday's every month. Technically, they are only supposed to work 2 weekends a month, and am attempting a way to create this in Excel to make it more fair to the group instead of just picking and choosing which weekend these employees work, I would like an Excel program to do this for me.
View 1 Replies
View Related
May 31, 2014
Im doing a spreed sheet to calculate employees hours. I have the employees names in column R and their hours in column S. example R5 = Mike S5 = 8. I need to search column R for all the mike's and total his hours, then move to the next employee and so on... I have already sorted the employees names so that all the names and hours correspond and starting in column R5 and S5 until the proceeding row is blank and then paste the results in column B5 (employee name) and D5(total hours)
View 4 Replies
View Related
Feb 11, 2009
I am trying to rank employees by seniority date. Some employees share the same seniority date. They should have the same rank. I took a formula from another thread =RANK(C2,C$2:C$8) and applied it to my worksheet and it worked out great except that the ranking skips the next number (in this case 4)...........
View 2 Replies
View Related
Mar 6, 2012
I am trying to write an IF statement. The IF statement should calculate BONUS for an employee GREATER THAN 50 YEARS OLD.
View 4 Replies
View Related
May 3, 2013
In a sheet, like the example, I have monthly shift schedules for employees. What I want is to count the total shifts for Saturday and Sunday, separately Night (N) and Morning (M)/Afternoon (A) shifts, as in columns with red.
ABCDEMNOPQRAGAHAIAJ1JUNE 20132DATE1234121314151617....
HOW MANY "N" HOW MANY "M" AND "A"3SATSUNMONTUEWEDTHUFRISATSUNMON....
AT SAT-SUNAT SAT-SUN4Employee1NNNNNMM--A205Employee2MMMM-NNNNN246
Employee3AAAAM--MMM067Employee4--MM-AANNM408............................................9EXAMPLE
View 6 Replies
View Related
Jun 26, 2009
=IF(C5>40,((C5-40)*D5*1.5)+40*D5,IF(C5
View 9 Replies
View Related
Oct 23, 2009
how I would be able to divide a budget of 100k for each of my employees.
If I have employees making anywhere from 20,446.40 - 69,659.20 How can I give each employee a portion on these funds?
For example if:
Lisa makes 20,446.40
Tom - 24,448.20
Liz - 34,854.60
Mike - 44,564.80
Jan - 62,061.48
Dan - 54,324.20
What would be the precentage that I could give each employee?
View 9 Replies
View Related
Apr 6, 2013
Basically I am trying to create a worksheet in which everytime I input information into Sheet 1, it is copied into Sheet 2. I want to have each entry in succession on Sheet 2 such that my first entry would be on Row 2, second on Row 3, third on Row 4, etc. However, everytime I put something new in Sheet 1, it just overrides the information in Sheet 2.
Basically I type in ticket sales in sheet 1, it calculates the prices and keeps a transaction log in sheet 2. But everytime I do a new ticket sale, it just overwrites the previous transaction witht he new transaction information. I've pasted my VBA below:
Sheet 1 VBA:
Code:
Option Explicit
'Form level variables - used in more than one event
Dim intAdult As Integer
Dim intStudentSenior As Integer
Dim intBalcony As Integer
Dim intChild As Integer
Dim sngAmountDue As Single
[Code] .......
Sheet 2 code:
Private Sub cmdSummary_Click()
'Declare Variables
Dim intCount As Integer
Dim i As Integer
Dim intAdult As Integer
Dim intStudentSenior As Integer
[Code] ......
View 3 Replies
View Related
Apr 15, 2014
I have to calculate employees work hours for overtime.
in the timesheets:
A B C D E
1 ID Date Code Hours PayMethod
2 A123 4/14/14 TRN 20:00 Regular
3 A123 4/14/14 TTT 15:00 Regular
4 A123 4/14/14 TRN 13:00 <----- total for cell D2,D3, and D4 is more than 40
A B C D E
1 ID Date Code Hours PayMethod
2 A123 4/14/14 TRN 20:00 Regular
3 A123 4/14/14 TTT 15:00 Regular
4 A123 4/14/14 TRN 5:00 Regular <----- to make 40
5 A123 4/14/14 TRT 8:00 Overtime <----- 13-5=8, so i have to write down 8 here for overtime
How can I do this?
I want to make a command button for macro to perform this.
View 2 Replies
View Related
Aug 3, 2009
Basically I have a list of employees. This list is simple in that it shows their off time "From:", "Till:". in columns to the left of there name. So in Cell A:A would list all of there names.. In the example sheet I have just a few listed. To the left of their name if "From:" (column B) and then "Till:" (Column C). And this From, Till repeats itself for several columns so that multiple off-times may be made for each employee.
Basically what I want to do is delete any sets of dates that are expired (based on the "Till:" date) and shift the remaining dates over. So in other words, if Sam has a date in there of 8/1/09 to 8/1/09 meaning he is going to be off for just that day, and today's date is 8/2/09, then that "from" and "till" date of 8/1/09 to 8/1/09 would get deleted from his list and the remaining dates (if any) would get shifted to the left.
Hopefully I have provided a good enough explanation of what I am trying to do here.. Please let me know if you have any questions! I have provided an example the reflects my setup (and the setup can be changed if it makes anything easier)
View 9 Replies
View Related
