Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media

    MS Excel macro to convert an indented hierarchy into a parent/child link list

    - or -

    Post a project like this
    1954
    $$
    • Posted: 5 years ago
    • Proposals: 7
    • Remote
    • #1982824
    • Completed
    Mahmoud A.
    Mahmoud A.
    Programmer / VBA Expert
    Top Endorsed
    Egypt Zagazig
    Dave G.
    Dave G.
    Microsoft Office and Web Developer
    Top Endorsed
    United Kingdom Leighton Buzzard
    Valeriy S.
    Valeriy S.
    Qlikview, Xcelsius, Excel and SAP BPC developer
    Switzerland Sementina
    Tejas T.
    Tejas T.
    Excel, Word & Powerpoint VBA Expert
    India Pune
    Roadometry
    Roadometry
    Lead Generation| Web Research| Data Entry| Virtual Assistant| Admin Support
    Top Endorsed
    Bangladesh Thakurgaon
    Islam A.
    Islam A.
    Excel/Access/VBA/Google Sheets/Zoho
    Top Endorsed
    Egypt Cairo
    Marion M.
    Marion M.
    IT Consultant and Developer
    United Kingdom Croydon
    144943350666351470352760144880114494731518289
    Mahmoud A.Dave G.Valeriy S.Tejas T.Roadometry + 2 others have already sent a proposal.
    • 6
    • 6

    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.
    •  
    Bart N.
    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 in

    Clarification Board Ask a Question

    • 20 Apr 2018Md P.

      Hello Bart,
      Is this still available?

    630264
    1954
    $$

    - or -

    Post a project like this
    Bart N.
    Bart N.
    100% (10)
    Projects Completed
    15
    Freelancers worked with
    14
    Projects awarded
    59%
    Last project
    5 Feb 2019
    United Kingdom

    Related project Searches


    microsoft excel

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2023 People Per Hour Ltd
    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