Direct & Indirect Reports

Discussion in 'Excel Programming' started by lg123, Mar 28, 2014.

  1. lg123

    lg123 Guest

    Hi All - I'm looking to have a simple output file created that will sho
    me how many direct reports and how many indirect reports every perso
    would have in a given data set (including a zero for those that do no
    have either)...

    - I have the below data fields to work with:

    Person Name; Person ID; Supervisor Name; Supervisor ID

    - I would ideally like two output tabs where one gives a summary:

    Person Name; Person ID; Count of Direct Reports; Count o
    Indirect Reports

    And where the second gives the detail:

    Supervisor A:
    Direct Report A____ Indirect Report D
    Direct Report B____ Indirect Report E
    Direct Report C____ Indirect Report F

    Count for both direct and indirect

    ___________________________________________________________
    Supervisor B:
    Direct Report H____ Indirect Report K
    Direct Report I____ Indirect Report L
    Direct Report J____ Indirect Report M

    Count for both direct and indirect

    ___________________________________________________________

    Any thoughts would be extremely helpful and appreciate


    --
    lg123
     
    lg123, Mar 28, 2014
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Mike NG

    Direct manipulation of TextBox

    Mike NG, Jul 12, 2003, in forum: Excel Programming
    Replies:
    4
    Views:
    143
    Bob Phillips
    Jul 13, 2003
  2. Pier Luigi

    any site for examples or direct help about userform

    Pier Luigi, Jul 12, 2003, in forum: Excel Programming
    Replies:
    6
    Views:
    221
    Gord Dibben
    Jul 13, 2003
  3. Steven Rosenberg
    Replies:
    4
    Views:
    149
    Tom Ogilvy
    Aug 5, 2003
  4. courtesio99

    direct to certain cells using drop down list

    courtesio99, Dec 9, 2003, in forum: Excel Programming
    Replies:
    1
    Views:
    109
    Bill Manville
    Dec 9, 2003
  5. shirley
    Replies:
    10
    Views:
    141
    Bob Phillips
    Mar 3, 2004
  6. Scott
    Replies:
    2
    Views:
    116
    Bob Phillips
    Mar 9, 2005
  7. Paula
    Replies:
    0
    Views:
    143
    Paula
    Mar 24, 2006
  8. John Menken

    List of Direct and Indirect Reports

    John Menken, Jan 4, 2012, in forum: Excel Programming
    Replies:
    7
    Views:
    497
    Ron Rosenfeld
    Jan 5, 2012
Loading...