manager

Hi I have found the forums here a great help in the past but never had to actually post anything for help, so I hope that someone will know a way to help me. The issue I have is that we track holidays and sicknesses at my company on one sheet, this has the dates along the top row, the staff's...

I have a list of about 38,000 employees, and in that list is a column of who each employee's Manager is. I want to generate a list of all Managers and identify the employees under them. For example, if Susan Smith (manager) has four employees, I would want to generate a list the employees under...

It was hard to title this one. Thanks in advance for your help. In cells A30 through A34, I have the following list: Assistant Manager Manager Coordinator or Treasurer Vice President President We have an "approval level" control that determines who needs to sign the requisition depending on...

Hello, I have a power pivot model with budget table, forecast table and keys table. Forecast table columns: Data Type, Manager Name, Client Name, Period, Amount, Month, Year, Key (Manager A_Client A_Month_Year) Example of table row: "Forecast", "Manager A", "Client A", Jan-17, 100, 1,2017...

I have a workbook with hundreds of names. As a result, the Name Manager is hard to navigate--see the image below. Additionally, nearly all my names are defined on a workbook level and refer to ranges, not tables. Consequently, the Name Manager's conventional filter options are useless for...

Hello clever people... I need some help which I think would be easy to someone that can do VLookups. I have a list of all staff on sheet 1, which has columns that include their first name, surname, department, line manager. On a separate tab, I would like to be able to count how many direct...

Hi, I have column A that has a project ID and a column that has a role related to that project. There can be multiple rows per project: I am trying to concatenate the multiple roles per project into one cell per project. Example Project ID Field ID A Consultant A...

Hi All, I have a VBA macro code that works on a organisational chart and works pretty well based on pre-defined criteria based on Levels.So for example there is a director of sales and Level 1 is a senior Sales Manager who would report to the director of sales and Level 2 is a sales Manager...

Hello, Trying to assign a name using the Name Manager for two separate ranges in two separate sheets, which would essentially merge the two. Ranges are A2:A1000 in Sheet1 and C2:C1000 in Sheet2. This named range will then be used in a formula to extract the unique values off of the two ranges...

Hey Everyone, I wonder if you can help me with some VBA for sending out reminder emails based on cell contents. I have a worksheet that looks like this: <tbody> Role Name Manager Name Manager Email Status Opp Date Recruitment Deadline 1st Reminder Email Sent 2nd Reminder Email Sent Officer...

Hello guys,i am an young intern in a big company and i want to impress my manager by saving the whole office a month worth of work. Right now we are trying to replace some information from PowerPoint Presentation models with other informations from excel spreadsheets,for example postal...

I am hoping somebody can help me here, my Raw Data is from a support org and has the Client service Manager, client names, Categories of work and hours worked in the raw data. What I need to do is create a pivot table that will look something like this <tbody> Category A Category B Category...

Hello, I need to automatically find the managers who will be responsible for each employee in a company. There are many hierarchy levels and each manager is responsible for his team of subordinates. I have all the columns A - K and I need to fill in columns L-M-N with the names (or job title)...

From the below. worksheet1 : In worksheet1 "duty" column. I need to find out what duty "worker" last had during work_order_date. Bill on work_order_date 08/01/2017 & 08/05/2017 should report back as "welder" because he was not yet a manager until 8/15/2017. worksheet1 Bill work_order_date...

I have 3 columns of data - around 50 rows. Col A is a date (Promotion year) Col B is last name Col C is rank (this is the same for all) Data example 2017 bloggs manager 2017 smith manager 2016 adams manager 2015 bloggs manager 2014 smith manager 2014 adams manager etc Can a formula...

I have a formula: SUMPRODUCT((PaygroupCode=B2)*(Nationality= {"Nepal","Sudan","Chinese","Japanese","African","British","American"}) *(TotalSalary)) My Query: How can I put the: {"Nepal","Sudan","Chinese","Japanese","African","British","American"} in a list and name it in the "Name Manager"...

I am using MsExcel 2016. On sheet 1 I have a list (300+ rows). Headed by last name and first name and title 1 and title 2 and date. On sheet 2 I wish to group that data by say; title 1 or by title 2 or by date. Sheet 1 example data Last name First name Title 1 Title 2 Date Smith John Senior...

Hello, and thank you in advance for any assistance I may receive. I have used this forum for years (I cannot retrieve my original account) and am so grateful that excel experts spend thier own time to look and solve complete stranger problems. I am at hour 4 on this and I just cannot make it...

Hi i am completing a word doc based on a userform entry's. The problem is i am not sure how change a bookmark depending on entry. I will try to explain. On occasions i write to company's or private landlords. So the addresses are like so = The Manager Mr His Name...

hi All, Need your expertise to assist me for below situation :- how can i extract the datetime (highlighted in red) in one cell? *** NOTES 01-Nov-2017 08:32:40 Axyz1 Action Type: Manager review *** Performed by contact: Anonymous Caller, (000)000-0000 Notes:SC- UPSELL...