parent

need to display parent, in parent column, where there is a parent child relationship based on an indentured level listed in a column Column A: Indentured Column B: Part Number Column C: Parent Indenture Part Number Parent 1- ABC 2- 123 3- 123.1x...

Hello Id be really grateful if anyone is able to tell me how to solve the following in VBA: I need to extract (into two columns on a separate sheet ideally) the child and parent relationship from a table of data. The table data range varies between 5 and 10 columns, with the right most column...

Hi, I wanted to create a Hierarchy, which can contain multiple parent and child. Input Data :- <tbody> Role 1 2 3 4 5 6 7 8 9 A R R R R B R R R R R R C R R R R R R R D R R R R E R R R R R R R F R R R R R </tbody> Role A - 1,2,3,4 So each Role is formed with...

<tbody> Hello. I'm trying to write a formula that would achieve the values in the "Parent SUMs" column, but it's proving a bit of a challenge. Essentially, my goal is to sum all "children" or sub-level values under each "parent" (including the value that resides...

Hello All, I have never done programming in VB so this is fairly new, had done some PB programming more than 20 years ago but can't remember anything :(. I exhausted in-built sort option Excel provides for what I want to achieve. I need some help in restructuring data that I download...

Hi! So I have come across a problem which can be very annoying. If you have a frame that is say 400 height by 800 width and has vertical scrollbar enabled then within this frame is another frame at position top 1 and left 1 of that frame and is height 700 and width 700. Well since the height of...

Sorry I don't even know what to title this. I had to exclude some of the data for anonymity, but this should be all the info necessary to do what I need. I have a list of products, some of them are in groups and some are not (I highlighted two groups yellow and blue for ease). If they are in...

I'm looking for some help - I have a cross reference pricing table which based upon the selection will give a price. What I would like is to enter the criteria in a number of selection boxes and for it to lookup the correct price. i.e. in the boxes I would have selected the criteria in green...

Dear All, I am trying to create a VBA macro which can extract parent part# for each part from a multi-level list. In the example shown below: Column-A = Muilti-level list AKA item# Column-B = Part# Column-C/D/E = Column-A split at dot delimiters Column-F = Required output (parent part#) from...

I have a spreadsheet with 4 columns: A - Child, B - Parent, C - Child contact, D - Parent contact Each Parent belongs to the same parent(this is needed for reasons unrelated to this issue) Each child belongs to a parent Each child can have none, 1, or multiple contacts. Each Parent can have...

Greetings All, i have data set consisting of parent and child connections. I need to find a way to extract parent its child and its child's child and so on. Data structure is like this <tbody> Parent Child A B A C B D C E C F F G F H F I G J G K </tbody> My formula is...

Greetings Excel Wizards, I need help with some code. I have a table. Its name is Table2. The first column of the Table is in Column B and its header(B2) name is FILE#. I'm looking for a way to have every entry (current and future) in the file column be automatically hyperlinked to a...

Hi. Long time lurker, first time poster. I haven't had a need to join any of the Excel forums as Google has been my friend. There's lots of great information out there and even if I can't find my specific solution, I usually can find enough details to drive me in the right direction...

Hi, I'm trying to automate Part# on a inventory spreadsheet but struggling. Below is my spreadsheet and the layout. The Part # for the Parent Item should be the concatenate of the child items comma separated. The Part # for the child should be the same as the Item Number like below. I've...

Hi, Short version: Someone knows about a VBA way to structure data under indented parent-tree when parent name is on same row in columns to the left? (Se bottom example) Long version: This is my first post here so please let me know if I'm writing this wrong. (Tried to read rules and search...

I have a large flat hierarchy table. I am looking for a method to select a parent and return a list of my lowest level children. I am somewhat familiar with VBA but I don't know where to begin coding this. Thanks so much for any help I am able to receive on this. This has been a great learning...

Hi everyone. I've found threads that cover similar questions to the one I have, but none which touch upon exactly what I'm looking for. This is also the first time I've posted in here, so I apologize if I do anything incorrectly. What I'm trying to do is create an additional column within...

Hello Everyone I have a list of employees and their managers in excel on Sheet1 (A2 through A? is the employee and B2 through B? is their manager). This goes (so far) up to 8 levels deep. I then have a data validation list that sources column A on sheet1 (The list of employees) that is located...

Hi there - Have an excel master template file with 2 sheets with a button on each with macro attached. Button on sheet 1 saves a copy of the Excel master file to a folder and names it based on a certain input cell values in that sheet. Button on sheet 2 saves another copy of a worksheet up...

We have a manual process that we want to automate. I’m hoping someone can advise on how to do this with a macro? I haven’t been successful in figuring out how to make this work. Thank you in advance for any help on this, Cindy Currently using Excel 2010 On a daily bases we receive an excel...