I would create a master list on a separate sheet with four columns, level, ID, blank, and parent ID. Then, using concatenate, create in the blank field a unique string based on level and ID. Include leading zeros as appropriate in levels to ENSURE unique outcomes.
Then, create a named range using columns three and four of your new master table.
Use vlookup and concatenate in your error prone list to produce a similar unique string, compare it to the named range, return column two, and False.
Regards
Paul
Sent from my iPhone
On 05/10/2011, at 0:35, "quasar58" <quasar58@yahoo.com> wrote:
> 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]
>
>
[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