Retrieve All Children

[willwonka]

I have a list with many columns; but the relevent columns to this
request are:

Account Parent Children

Account is the Account
Parent is the Parent to that Account
Children is the number of children to this account (of which some
could be other parents).

Is there an easy way to have some macro pull the bottom level (leaf
level) accounts to a certain parent. These account would have 0 in
the Children Column.

So for Acct ZZCBNMKT (see below) it would return

BM5102
BM5104
BM5106
BM5108
BM5114
BM5116
BM5120
BM5121
BM5126
BM5140
BM5150
BM5151
BM5152
BM51525117
BM5170
BM51800050
BM51800001
BM51800004
BM51800014



| | | + ZZCBNMKT - Total CBN Marketing
| | | | + ZZCBNMKTGR - Total CBN MKTG
Gross
| | | | | + BM5100 - CBN MK
Salaries, Wages & Bonus
| | | | | | + BM5102 -
CBN MK Salaries & Wages
| | | | | | + BM5104 -
CBN Vacation Accrual
| | | | | | + BM5106 -
CBN MK Bonus
| | | | | | + BM5108 -
CBN MK Incentive Pay
| | | | | + BM5114 - CBN MK
Overtime
| | | | | + BM5116 - CBN MK
Commissions
| | | | | + BM5120T - CBN MK
Total Employee Benefits
| | | | | | + BM5120 -
CBN MK Employee Benefits - Historical
| | | | | | + BM5121 -
CBN MK Health & Welfare
| | | | | | + BM5126 -
CBN MK 401k
| | | | | + BM5140 - CBN MK
Payroll Tax Expense
| | | | | + BM5150 - CBN MK
Capitalized Payroll
| | | | | + BM5151 - Temporary
Help
| | | | | + BM5152 -
Contractors
| | | | | + BM51525117 -
Selling Partner Commissions
| | | | | + BM5170 - Travel &
Entertainment
| | | | | + BM5180 - Education
& Training
| | | | | | +
BM51800050 - BM Education Reimbursement
| | | | | | +
BM51800001 - Education, Training & Professional Development
| | | | | | +
BM51800004 - Education & Training Local (From)
| | | | | | +
BM51800014 - Education & Training Local (To)

 

[Joel]

I've done this plenty of times. Can you post your data at
http://www.thecodecage.com and send me an updated posting with the link where
the file is located. the data that you psoted had lines that were too long
and was wrapped onto multiple lines. Without the exact data I don't think I
wil be able to accurately write the macro,