Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Page 2 of 2 FirstFirst 1 2
Results 11 to 17 of 17

Thread: Mapping a Hierarchy of an organisation in Excel

  1. #11
    Join Date
    24th December 2004
    Location
    Nanaimo, Vancouver Island, British Columbia, Canada
    Posts
    2,464

    Re: Mapping a Hierarchy of an organisation in Excel

    Hi.

    1) The file in Post #4 works fine for me.

    2) "tweak" it? How? Post an example of your data maybe.
    Cheers,

    dr

    "Questions, help and advice for free, small projects by donation. large projects by quote"

    http://www.ExcelVBA.joellerabu.com

  2. #12
    Join Date
    18th August 2010
    Posts
    12

    Re: Mapping a Hierarchy of an organisation in Excel

    Hi

    Here's the file.
    I have got the following data in my file:

    1. column A : employee job ids
    2. column B : manager job ids
    3. column C : reporting tier.
    4. the top boss is employee id "5000000001"
    5. I have created a Pivot sheet and then copied and pasted the output I want in the "Desired Outcome" worksheet.
    I was hoping that your "hierarchy.xlsm" worksheet could be used to produce the desired result. But somehow I am not getting the same results.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #13
    Join Date
    18th August 2010
    Posts
    12

    Re: Mapping a Hierarchy of an organisation in Excel

    Hi Rbrhodes,

    I had started a new thread about creating an organisation hierarchy. I have received a response to my post and the solution provided has worked for me. Thank you for the help.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #14
    Join Date
    24th May 2012
    Posts
    1

    Re: Mapping a Hierarchy of an organisation in Excel

    Hello all,

    sorry to revive such an old post, but its really a quick question over here.

    Im trying to use Junho Lee's macro for creating the tree style hierarchy.. It works well when I use it in the original spreadsheet (junho.xls)

    But when I copy the macros to my own spreadsheet it misses the "node" declaration..

    VB:
    Dim arrName As Variant 
    Dim arrParent As Variant 
    Dim arrMatrix() As Variant 
    Dim arrTemp As Variant 
    Dim elm As Variant 
    Dim i As Long, j As Long 
    Dim ret As Variant 
    Dim node As node 
    Dim bExists As Boolean 
    
    
    cant seem to figure out where this node declaration is..

    any hints?

    Thanks in advance..
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #15
    Join Date
    16th July 2015
    Posts
    7

    Re: Mapping a Hierarchy of an organisation in Excel

    Hi rbrhodes

    Need one minor change in the code..
    I want "Report to" field as an input field..
    Based on that value, I want tree diagram to be generated..

    also with reportee count at each node
    highly appreciate your help..


    regards,
    Gaurav

    Excel Video Tutorials / Excel Dashboards Reports


  6. #16
    Join Date
    1st September 2010
    Posts
    10,912

    Re: Mapping a Hierarchy of an organisation in Excel

    Please start your own thread.

    Give it a title that accurately and concisely describes your issue and explain your problem fully. If you think this, or any other thread, can help clarify your issue you can include a link to it by copying the URL from the address bar of your browser and pasting into your message.

    Excel Video Tutorials / Excel Dashboards Reports


  7. #17
    Join Date
    15th September 2005
    Posts
    3

    Re: Mapping a Hierarchy of an organisation in Excel

    Hi, this thread solves my issue, but the workbook attached is an older version of excel. Do you know how I can change this to a 2016 version in which the row limit is not 66k and the macros still work?

    Thanks,

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Intermediate Pivot Table Organisation
    By Shonnn in forum Excel General
    Replies: 1
    Last Post: June 10th, 2010, 01:16
  2. Rearrange data In Hierarchy To Table`
    By Belinda Li in forum Excel General
    Replies: 14
    Last Post: June 19th, 2007, 05:09
  3. get file\properties\author & organisation by vba
    By DROM in forum Excel General
    Replies: 2
    Last Post: April 29th, 2006, 14:50
  4. Replies: 1
    Last Post: March 21st, 2006, 07:06
  5. VBA Account Hierarchy- Text to Multiple Colum
    By udhay28 in forum Excel General
    Replies: 8
    Last Post: March 20th, 2006, 15:14

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno