A pivot table based on columns AO:AR on the Level 1 sheet comes close to what is shown on the Output - Hierarchy sheet.
I feel that the best way to know if a formula/pivot table based approach will be feasible is to test it on the actual data.
I don't know enough about VBA to say whether or not a macro would help with replicating the Output - Part sheet.
I had seen that this was a VBA question, but decided to reply to the thread when I saw it had gone two days without one.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you JeteMc.
Hierarchy is fine.. The data I shared are the actual data.
Also, in the Output - Parts are the lowest level parts for which I need to populate the Top level assemblies that the part is reporting to.
Can you pls help on Output - Part sheet. It should show all its unique assemblies that it is reporting to.
Ex:
Parts Where Used
70071078 -> 109494602,109494702,109494802,109494902,109495002,109495102,120007555,120007557,120007558
70071823 -> 109494602,109494702,109494802
70071827 -> 109494602,109494702,109494802,109494902,109495002,109495102
70072535 -> 109494602,109494902
60002313 -> 109494602,109494702,109494802
60002080 -> 109494602,109494702,109494802
70070671 -> 109494602,109494702,109494802,109494902,109495002,109495102,120007555,120007557,120007558
70211123 -> 109494602,109494702,109494802,109494902,109495002,109495102,109582202,109582302,109582402,109582802,109582902,109583002,120001431,120001432,120001433,120001434,120001435,120001436
and so on
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks