Sallie Francis
New member
- Joined
- Feb 23, 2012
- Messages
- 2
- Reaction score
- 0
- Points
- 0
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.
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.