managers

Morning all I'm struggling with coming up with a formula to count the number of managers in a list. I have a dataset that includes week numbers, regions, deals and managers. I need to come up with a count of managers for a specific week and region. I keep coming back with the overall count, I...

Hi there, I'm producing some graphs based on a set of questionnaires. Some are Likert Scale statements and some are simple yes/no/don't know questions. We are trying to split the answers down by type of respondents: Amenity manager; productive managers; multi-functional managers; and...

Hi All, I developed a tool for employees in different dept. and the tools automatically captures data filled and send it to the tables (Which i created in different tabs, which are hidden from the employees). After that comes a validation tab where only managers are allowed to see it. The...

Hello, I have data in two tables, and I need to apply conditional formatting where the data matches and where it differs. For example: if I have a business that has 2 general managers and 3 assistant managers (table 1 - this data will change), and they should have 1 general manager and 5...

I attached a dropbox link so it’s easy to follow along. In this roster, I have a sheet labeled setup. In there aremanager names to reference, I want these three managers to be transferred intotheir own workbooks (individually: manager 1, manager 3, manager 5). In Sheet1,Column AR is where...

<tbody> Mgr Lvl2 Mgr Lvl3 Mgr Lvl4 Mgr Lvl5 Mgr A Mgr AA Mgr AAA Mgr AAAA Mgr AB Mgr AAB Mgr AAAB Mgr AAC Mgr AAAC Mgr AAD Mgr AAAD Mgr AAAE </tbody> I have a roster file that I need to cut up in a bunch of different ways. It has employee info and it needs to...

<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'm trying to create a dashboard that pulls from a different worksheet how many employees per manager are located in one of three regions. Here is what I have.... Worksheet 1 = HR EE Roster as of 04-05-18 has 37000 rows of employees (Column G has Country initials; Column L has Manager's Empl...

Hi all I was hoping someone can help me with some VBA to achieve what I am looking for. Basically on Sheet 1 the users enters a list of names in Column A and then dates of employment in Columns B to C. So in the below example Jack was employed from 01/01/1980 until 31/12/1985. Sheet 1...

Hi! I have pivot table that consists of 3 elements Left Column is a store name Next Colum of Table is a Grand total field of Sold Quantity and Unsold Quantity of items. I created 4 macros and assigned them to 4 different buttons : 1. Show Salesperson Name 2. Hide Salesperson Name 3. Show...

Hi there, I'm looking for advice on the best way to go about constructing a module to get my desired result. I have a commissions file that i want managers to be able to go in and review the commissions. Each manager will have a username and password. Each manager will require access to...

Hi All I have a macro which is applied to all worksheets except 'configuration' or 'project managers' worksheets. However, when I run it, it seems the macro also affect these two worksheets. Please could someone help me to resolve this? Many thanks. The macro starts with: Sub report() Dim...