Results 1 to 3 of 3

Thread: Raw Data into outline/grouping

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Raw Data into outline/grouping

    Hi,

    I have a set of raw data that is essentially linked to each other by a UID and Parent. I need to find a code that looks up a value, inserts a number of rows based on that value, copies data (with indent for grouping) and then looks up the next value, counts how many times this item appears in the list and copies data (with indent for grouping) and repeat until all complete.

    For example
    Column A (UUID) e.g. 1147
    Column B (Parent UUID) e.g. O
    Column C (Name of Parent) e.g. Main Parent
    Column D (List Value) e.g. Maintain Records
    Column E (List Value Level) e.g. 1
    Column F (List Value Children UUID) e.g. 1147
    Column G (formula to count how many children list value (D) has)) e.g. 4 (looking up how many times 1147(F) appears in Parent UUID (B)

    This Tells me the group/outline view would look something like this;

    Main Parent
    Maintain Records (UID 1147 | 2 children)
    1. Amend Form (UID 91 | 12 children)
    1a Communicate Impacts
    1b Confirm Impact Type
    etc.
    2. Create Form (UID 546 | 11 occurances)
    2a Assign Form Number (UID 244 | no children
    2b
    2c
    etc.

    It is this view (with proposed indents and group + and - where numbering is) I am trying to receive however numbering is not essential.

    I have racked my brain trying to work out how to get this view and have played out a couple of manipulation codes to no avail. I have also noticed that what part procedures I have come up with like looking up value in column G and inserting # of rows copying values takes forever and is only one part of the process as I would need a code to include repeat of column G formula to look up the value based on the next line.

    Anyhelp on this would be greatly appreciated. I am self taught with VBA so maybe looking at this from comletly the wrong angle. Its important to note that the full file is over 5000 lines. I have attached a sample.

    Thanks in advance
    Sal.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

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