Nested Excel Logic Mindbender

[echeech]

The basic problem I am working with is... "Here is a list in excel of everyone in the company (empl id in column A, supervisor id in column B)... Determine the Vice President that each person rolls up to."

Everyone has ids and I have the list of VP's; the quirk is that while some may have a VP id in the supervisor field, most have a manager's who have the VP id as their supervisor. There could be 2,3,4, etc steps up to finally roll up to the VP.

I am thinking that a loop using a flag needs to be used, but the logic and syntax are bogging me down. If a specific example is needed, I can provide. HELP!

 

[jbeaucaire]

We just addressed this same situation today in a thread here:

http://www.excelforum.com/excel-programming/720504-setting-up-tree-structure.html

Post #5 has a macro designed to handle it for the layout given. Perhaps you can adjust this to your needs?

 

[echeech]

I'll take a look. Thanks for the quick response!

 

[jbeaucaire]

There was an error in the macro in post #5, use the one further down.

 

[echeech]

Rather than build the actual tree out, I just need to identify the ending VP, if possible in the 3rd column.

Also, I can't view the excel files for the given macro so I'm unsure of file structure so I can adjust to my simple two column file.

Thanks

 

[jbeaucaire]

I think you need only register (free) to be able to download files from there.

Alternately, the site in my signature includes contact info, you can send the file and I'll look it over.