Thanks Paul. Let me know try it out and report back.
Dinesh
--- In ExcelVBA@yahoogroups.com, "Paul Vermeulen" <paul.vermeulen@...> wrote:
>
> 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@...> 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