employees

Hi there, For the problem i have, i thought a pivot table would work, but it doesnt. I will try explain as best as i can. Column A - Task List (about 100 of them) Column B - Monday Column C - Hours Column D - Tuesday Column E - Hours ... and so on. Under the "day" columns, we enter an...

I have a workbook with employee information that needs to be put in a public folder for employees to have access to. Is there a way I can hide about 5 of the worksheets allowing other employees access to only about 4 other worksheets? I need for the employees not to be able to unhide those...

Good day, I have a full list of employees on one sheet (master sheet). And a few other sheets (sheet 1, 2, 3, etc...) that will be filled in with the employees name. What I need is to have a formula on the master sheet that looks at Column C, Row 4 and down on each sheet to compare the same...

Hello, I am looking for a formula/method to calculate the headcount by hour of day. I have employees whose shift crosses midnight hours. e.g. employee Start End A 06:00 14:30 B 14:00 22:30 C 22:00 06:30 Now I would...

Overview of what i am trying to achieve - I have a list of data that could be 1000 rows long and i want to send an email to everyone manager on the list as a reminder to do something but if a manager appears on the list more than once this means they have multiple employees with the same issue...

<tbody> Employee# ColumnA ColumnB 14900 support 14900 communication 14900 communication 15038 support 15038 communication 15039 support 15062 support 15062 support 15062 communication </tbody> I need help creating a formula that will get the unique value of employees...

So we will eventually have three spreadsheets, but for now we're getting the ball rolling with two. The first sheet is for individual employees to keep track of issues that arise. Various columns to track the aspects of each issue. I wanted to have the data automatically written from the...

I am looking to distribute an amount over several employees as a bonus. I have a different percentage I would like to give each employee. How would I go about this? For example, I want to distribute $1,000 over 5 employees. TIA!

Hi, -I'm tryingto create a spreadsheet which enables me to filter a list of salariesso that I can display the maximum wage for employees after an annual increase.I’ve tried using the VLOOKUP, but unfortunately I can’t get it to work asintended. I’ve used the function in the example below...

I have seen templates that calculate pto time and keep a running balance. However, I have not seen one with our company scenerio. We zero out pto time at the end of every fiscal yr and begin the new yr with a zero balance. Our employees earn pto time based on the hours they work every 2 wks. We...

I have a spreadsheet that details each employee's sales for each day. I currently use the following formula to calculate an employee's sales figues between 2 dates located in cells G5 & G6. Cell D6 contains a drop down list containing each employee's name. I'd like the exact same result but to...

Hello and thank you for reading my question. I’m building a pivot table to tabulate the employee count of my company as of a certain date. I’m simply counting the total number of employees labeled as Current, New Hire, Re-hire, and Terminated. In order to arrive at the correct number of...

I have a table where in C or F, you can have the ID of employees. Is there a way to sort this table if either of the Columns meet the criteria:"AZ83764"? Many thanks in advance

We have a file with 3000 employees called Database.xlsb thatstores employee ID in Column A. We also have Local files (i.e. local1.xlsb, local2.xlsbetc.). Each local file can hold up to 200 employees. We would like to transferdata from local files to Database.xlsb. i.e. in Local file we may...

Hi Everyone, I am currently looking for a way to have it so when a manager is working with an employee on their development plan they are able to have a quick way to plot multiple employees on to a 9 box grid with the click of a single macro. Both the performance and potential rating scale from...

I need to randomly select from a list of names for people to work at a customer appreciation bar in our hotel during weekdays. There are 17 names that need to be selected for the 20, 21, or 22 workdays for the month. No weekend dates. Eight of the employees can be selected only once while the...

Happy Friday! Looking to see if there's a way to do a conditional format of a column of states that have mixed in non-US locations Currently I have a list of employees and the states they cover John Smith, MD, WY, TN Arron Smith, OK, TX, FL Each of these is a separate column. I then have a...

Hi all, i would like to develop the below VBA code, so that when i save the file "Employees Finger" 2nd, 3rd, 4th time, e.t.c to enter a new sequence number at the end of the file. e.g. "Employees Finger1", "Employees Finger2" and so on..... Tks in advance ChDir "C:\Users\User\Desktop"...

I have an excel file that has a list of employees (column a), their manager name (column b), and manager email (column c). In many instances different employees may have the same manager. I want to use a macro to automatically send one (1) Outlook email to each manager along with the names of...

<tbody> Employee Name Title Salary max sales min sales Archie Moody TI 14 327 96 Dixie Daniels T3 35 170 109 Jennifer Palmer T5 16 320 317 Camille Ortega T3 12 257 213 Arlene Carr T2 12 289 240 Neil Mills T1 17 352 116 Terri Bridges T4 38 172 110 Terrell Cortez T1 30 292 105...