supervisor

I have 3 tables, One is a workorder table that has the due date of some 300 workorders (obviously dates are repeated) Second table is a supervisor table for dates that supervisors worked (again repeated dates) Third table is a calendar table I created through PowerPivot I am trying to merge...

I have two tables one that shows all of my work order data and a column called due dates that a user manually updates to assign due dates to a given work order. I have another table called supervisor that has dates that supervisors worked, and any comments they may have added to the table...

Hi! I am really hoping someone can help me. I have a list of about 3,000 employees, with one supervisor ID tied to each employee ID. I need a list next to each supervisor ID that gives me all of their direct reports and their indirect reports. I wanted these ID's to populate in separate columns...

I am trying to create a list of unique values that relate to another list of unique values. Column A has a list of managers and column B has a list of supervisors that report to the manager in column A. There will be multiple supervisors that report to a mange, but no 1 supervisor will report...

I am trying to create a list on one worksheet based on data from another worksheet using two drop down boxes. I have a main spreadsheet that houses a list of operators, with their corresponding status (active, dropped, termed) and supervisor name. I would like to be able to select the supervisor...

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...

What I'm trying to build is a formula that will search a range of cells and return a specified text value if there's a match. Specifically I'm looking for names which may appear along a reports to hierarchy, 1-7. If the formula finds a particular name, any where in the range, I want it to...

If anyone can help with code below it would be very much appreciated. I’m at loss as I’ve reworked the code below multiple times with no success. I’m trying to do several three things in sub but can’t get everything to work. Thing 1: I want to determine if person—supervisor or...

Good day, I have a workbook where one of the tabs contains tables that feed the lookup on other tabs. The situation that I need assistance with relates to the supervisor of an employee for tracking and statistics. Until recently, the table had the employee name, employee number and name of...

Morning all I am looking for VBA to enable me to search my spreadsheet where the 'Grade' column is equal to 'APP' I have the autofilter as Sub check3() Range("A:1:X1").Autofilter6,"=APP" I know I may not need this, but want to leave it in, to let users see it has worked. What I am looking...

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> Manager Supervisor Manager Supervisor Manager Supervisor Average Daily work production 85 80 89 84.67 Accuracy of work 85 90 89 89 90 </tbody> Above scores is given by managers and...

I am currently working with a list of 20K plus names. Each name has a "supervisor name" associated with it. However, I am trying to utilize this formula to show all people under specific supervisors when one is listed...

Hi All i have a project that is outside of my current skill set. I'm not asking for someone to do it for me. sorry if this makes no sense. just want to make sure 1. if my idea is even viable 2. suggestions on possible area's issues may arise. 3. am i using the correct terminology. 4. people to...

Excel noob here. Each week I have multiple spreadsheets where my sole task is to alphabetize them by employee name and to manually insert their supervisors name next to them. This is incredibly time consuming for me. How can I make it so entering the employees name will yield their supervisors...

Hello, I am looking to perform a SUMIF but with names. For example, say there are different supervisors in column A and I want to find the amount of agents a particular supervisor has listed in column B (without doing a filter). Say supervisor JOHN CLOUD is in Column A2 and then in random rows...