I am a rare visitor to this group, so pardon if I inadvertently break
any protocols.
I need some code to remove a very error prone / manual step I have to do
monthly. See below. The requirement is to assign Parent Organization ID
to a Organization List.
There are three(3) columns
Level - the level number in an organization
Org id - the organization unique ID
Parent Org ID - this is column I need to fill in based on Level.
Starting at the lowest level (level 7 below), I need to determine the
Parent ORG ID and assign it to each child Org (level 7 parent = level 6
org). Note - orgs change frequently, so you have to assume maximum
levels could vary month to month.
Any assistance appreciated!
Level Org ID parent Org ID4 90011707 05
90012790 900117076 90012738 900127907 90012527
900127387 90012528 900127387 90382244 900127386 90012833
900127907 90012529 900128337 90118704 900128336 90206553
900127906 90320097 900127907 90035902 90320097
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar