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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Mike NG

    Direct manipulation of TextBox

    Mike NG, Jul 12, 2003, in forum: Excel Programming
    Replies:
    4
    Views:
    119
    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:
    200
    Gord Dibben
    Jul 13, 2003
  3. Steven Rosenberg
    Replies:
    4
    Views:
    127
    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:
    89
    Bill Manville
    Dec 9, 2003
  5. shirley
    Replies:
    10
    Views:
    126
    Bob Phillips
    Mar 3, 2004
  6. Scott
    Replies:
    2
    Views:
    101
    Bob Phillips
    Mar 9, 2005
  7. Paula
    Replies:
    0
    Views:
    109
    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:
    394
    Ron Rosenfeld
    Jan 5, 2012
Loading...