Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parent/Child Macro
I am looking to get some big time help on writing a macro or formula
to fill out the parent id based on the child id. I have filled out some of the parent id's to show how it should look. Basically the parent id follows a general wbs structure where .01.01 would be the parent of .01.01.01. Any help would be fantastic. thanks Child id Parent id V/0047.FNG.01.01 V/0047.FNG.01.01.01 V/0047.FNG.01.01 V/0047.FNG.01.02 V/0047.FNG.01 V/0047.FNG.01.02.01 V/0047.FNG.01.02 V/0047.FNG.01.03 V/0047.FNG.01 V/0047.FNG.01.03.01 V/0047.FNG.01.03 V/0047.FNG.01.03.02 V/0047.FNG.01.03 V/0047.FNG.01.03.03 V/0047.FNG.01.03 V/0047.FNG.01.03.04 V/0047.FNG.01.03 V/0047.FNG.01.03.05 V/0047.FNG.01.03 V/0047.FNG.01.03.06 V/0047.FNG.01.03 V/0047.FNG.01.04 V/0047.FNG.01.04.01 V/0047.FNG.01.04.02 V/0047.FNG.01.04.03 V/0047.FNG.01.04.04 V/0047.FNG.01.05 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
parent/child relationship between rows? | Excel Worksheet Functions | |||
Creating child worksheet from parent | Excel Worksheet Functions | |||
Parent/Child Field | Excel Programming | |||
parent/child ranges | Excel Programming | |||
Sorting Parent Child | Excel Worksheet Functions |