MS Excel macro to convert an indented hierarchy into a parent/child link list
- or -
Post a project like this1954
$$
- Posted:
- Proposals: 7
- Remote
- #1982824
- Completed
Description
Experience Level: Intermediate
I need an excel macro to convert a hierarchy represented in the XLS attached into a link list in the same XLS file. The macro should use standard XLS functions.
The hierarchy is represented in columns A-I and the target link list data to be placed in columns (J-M)
An example of the file to be converted is attached and expected data results are represented in rows 4-17 incolumns J-M
The macro needs to work with different size hierarchies and up to 8 levels on a variable length of list.
The hierarchy is represented in columns A-I and the target link list data to be placed in columns (J-M)
An example of the file to be converted is attached and expected data results are represented in rows 4-17 incolumns J-M
The macro needs to work with different size hierarchies and up to 8 levels on a variable length of list.

Bart N.
100% (10)Projects Completed
15
Freelancers worked with
14
Projects awarded
59%
Last project
5 Feb 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hello Bart,
Is this still available?
630264
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies