parent

Hi, I'm new to Excel Scripting. I need help to create below parent child relationship in excel. I have the source file in below format. <colgroup><col span="4"></colgroup><tbody> Level1 Level2 Level3 Level4 PC_BMROA CD_KENBM 24158 009 PC_BMROA CD_KENBM 24158 010 PC_BMROA CD_KENBM...

Hi all, I'm somewhat new to this linked drop down lists thing and I'm having a little problem with it. I was able to make two dependent lists that work really nice when I'm first selecting the options as you can see in this first picture: But then, when I change the value in the first list...

Hello, I would like to ask for help with following problem. I have a list of strings in column A, from row 1 to row 3100, the text expresses a relation between Operators and Elements. Example: OR, Con1 SEQ, Con2 OR, Con3 PX, Con3 PX, Con2 OR, Con6 2xPX, Con6 PX, Con6 DD, Con1 SEQ...

Data as below <tbody> Parent Child AAA BBB BBB CCC AAA DDD DDD EEE EEE FFF CCC GGG GGG HHH HHH III III JJJ III KKK JJJ LLL KKK MMM MMM NNN </tbody> and continues. Output should be collapsed. EX. as below <tbody> AAA + BBB + CCC + GGG...

I have created a dependent list which will display selected values based on the parent list. Now I am looking for a option to clear the contents in dependent list when i change the selection in the parent list. Ex: Column K2 to K400 i have the parent list (Transport, Admin, HR) Column L2 to...

Hello Folks, i need to copy datas from a specific sheet(Summary) of multiple workbooks in a folder to a specific sheet(Summary) of the parent workbook. I will run the macro from the parent file. I tried by best, it is beyond my basic knowledge. I leave it to you guys. My inputs: 1. Sheets name...

Why is the name of an active chart in the Parent of the chart? what is the parent of a chart if it's not the worksheet?? Thanks (this question is not a problem-solver, I just want to know the specific hierarchy...)

Dear Friend How to edit code VBA for the VBA Vlookup another sheet please see table and ad visor:eeek: Thank you lotto Beginner VBA Sheet1 <tbody> item Detail Age School name Mother Country parent 1 david 17 T 2 job 12 G 3 steep 13 H 4 art 15 I </tbody> Sheet2...

CompanyID Total_Sales 1 5 2 5 3 5 4 5 5 5 I have a measure Total_Sales. The total needs to be allocated to the parent company in another measure. The parent company has an ID of 1 in the example above...

I'm not sure how to explain what I need so hopefully the cells below explain. I have created some dummy data similar to what I need. I'm trying to create a formula to go into the parent column (G) that will return the value from the part number column (B) of the parent above. All parents are a...

Hi wonderful people. I'm hoping you may be able to help. Apologies if this has already been solved elsewhere. I have HR data like the inout data table below where I have manager and subordinate employee numbers. I'd like to find some VBA code to output the table to the right below. In...

Hi Guys, I need some help finding a formula that will give me the total sales units of an item where I need to add the sales units of the "Parent" and the minimum sales units of the "Box" that relate to the item. For example below, Item 1 is the sum of Item 1 (Parent) + minimum of (Item 1 Box...

Hi, I have this macro: Sub FilterIt() Dim Ws As Worksheet Dim Source As Range, Dest As Range 'Refer to the data source sheet With Sheets("Active Listings") 'Prepare to be sure If Not .AutoFilterMode Then MsgBox "Create an Autofilter and try again" Exit Sub...

I have two tables in an Access database, a parent and child. I have a connection, and two ADO recordsets, one each for the parent and child tables. They're both opened with a string of SQL, adOpenDynamic, adLockOptimistic, adCmdText. The logic is to see if something specified in the spreadsheet...

Hi Excel Guru's, Looking for some advice on the best way to approach what I'm trying to do... after attempting to google or search the forums I think I'm failing to accurately search/describe what I'm trying to do and have resorted to creating this thread. 1. I'm trying to first reference a...

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 want to run a check before the user leaves the tab. Private Sub Worksheet_Deactivate() ' Range("D1").Select ActiveCell.FormulaR1C1 = "=SUMIF(C[1],""parent"",C[9])" Range("D1").Select ' If Application.Range("D1") > 0 Then MsgBox "You or Someone has entered estimated...

I have a spreadsheet and am needing help splitting the data into multiple columns and adding name ranges. Spreadsheet has 5 columns (A-E) Columns C, D, and E are related. Column C contains an Inventory Name, Column D contains a Parent Rule, and Column E contains a Child rule. I need the data...

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

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