child

I am looking to write some code that will take a flat file and create a child/parent hierarchy from it. The flat file is sorted in order so that each new row is either a new level in the heirarchy or a new child member. This is a sample of the sorted flat file from which the hierarch should be...

I have two columns, the first is a list of names and the second states if that person is the "Parent" or the "Child" (Columns A&B starting in Row 5) On a separate tab I want to have a list box where the user can select the name to be entered into that field. But I want the list to only show...

Hi guys, please help... I am trying to create a series of indirect lists but only lists that link to their relative tree. If say for example Parent "a" was selected, I would only have access to values directly linked with "a" (such as "a1.1, a1.2, a1.3, a1.4, a1.4", "a2.1, a2.2" and so on) and...

Hello all, First post hope someone can help with this. On Excel, I have about a list of about 2000 rows. With parent fields and then a child field below it - all on one column. Not all parent fields have a child field. But all child fields are indented to one - these are all indented to "7"...

In the following how would I count the cells that contain "Child Folder" and then extract that cell less the words "Child Folder" please? The returns I'm after are in cells C1:C4. Excel WorkbookABC1Child Folder: Cycling32Elham Valley Cycle Ride.pdfCycling3Giro 2014.pdfWalks4Miner's Way Cycle...

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...

As a long time member of MrExcel, I'm hoping all the Aladin Akyurek genius-types of folks can provide some desperately needed help -- I've been searching for weeks and not finding a *single soul* that knows anything on this topic or it's Excel functionality which seems shocking!?! With client...

I have a master workbook which opens several child workbooks (1 to 99 workbooks). I have macros to open and close all the child workbooks. Each child workbook is a business case for a project and the master workbook summarizes and combines all the projects. I modify the child workbooks and the...

<link href="safari-extension://com.texthelp.webreader-S98PLZJ32T/67d582e9/src/styles.css" rel="stylesheet" type="text/css" title="rwstyles">******** type="text/javascript" id="$th_texthelpReturn">function $th_doReturn(a){var...

Hi, I am a teacher and need to record the results from collaborative paired projects for my class. The idea being that I am able to see the effect of different partnerships on test results. I also need to set incremental targets based on personal attainment. I am struggling to write the formulas...

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 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...

If column B2 has Husband, B3 has Wife, B4-B5 has Child then starts over, how can I index each family unit ie: column A2 through A4 = 1 and increases with additional families. <tbody> Index Member 1 Husband 1 Wife 1 Child 1 Child 2 Husband 2 Wife 2 Child 3 Husband 3 Wife 4...

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 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...

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...

Hi folks, I have a simple website export of category names which are parent & childs of each other. They all reside in column "A". In column "B" & "C" I have the Category ID & Parent ID which is effectively a parent Category ID. "0" is the "Default Category" or master root if you like and what...

ok... so here is something i'd love to do, but i'm not sure if it is possible. i've been researching the whole "taking control of IE via vba" thing for a while, and i've got a spreadsheet that works well for what i want to do. now... here is the serious question. - Is it possible to have...