managers

  1. J

    Count number of unique values with multiple criteria

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

    Producing graphs representing segments from different sample sizes

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

    VBA/Macro Button Password Protection

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

    conditional formatting

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

    Is there a way to do this in VBA without inserting a new Column A?

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

    Can I cycle through this autofiltering and then transfer the data to a new workbook? VBA

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

    How do I come up with a formula to average cells?

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

    Calculate # of People In Region By Manager

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

    VBA: Splitting date ranges by date

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

    VBA Error on a Macro When Used in Conjunction With a Pivot Table

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

    VBA - Open certain sheets based on a range

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

    VBA applies to selected worksheets

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top