massive sorting exercise!

Hi
I have been tasked with a massive sorting exercise, example below

S/S pf a list of assets that each have a unique asset number.
Each asset is linked to a Parent asset through the unique asset number.
The data dump has not sorted these assets into the hirerarchy view (thats
what i have to now do)
Need to create either a macro or something to perform this function on 100+
s/s that have between 50k to 20m of data.

example

L&E
Lifts
Lift Car
Doors
Walls
Floor
Ceiling
Lift motor
Gear box
Motor
Sparks


I am sure you get the kinda of idea - any help on this would be excellent!!
Thanks Pete

go through the list
check if there is a parent assest
if so, insert a cell on the left and place the parent asset name there
(determined through the unique asset number). On the right end, put in the
parent assets unique asset number
continue to do this until you don't have any more assests in the leftmost
column that have a parent asset.
remove all the extraneous unique asset numbers from the right side
sort the data. If you want an indented list, remove parents

Excel only has 65K rows, so 20M will not fit on the sheet.

--
Regards,
Tom Ogilvy





"Little pete" <[email protected]> wrote in message
news:[email protected]...
> Hi
> I have been tasked with a massive sorting exercise, example below
>
> S/S pf a list of assets that each have a unique asset number.
> Each asset is linked to a Parent asset through the unique asset number.
> The data dump has not sorted these assets into the hirerarchy view (thats
> what i have to now do)
> Need to create either a macro or something to perform this function on
100+
> s/s that have between 50k to 20m of data.
>
> example
>
> L&E
> Lifts
> Lift Car
> Doors
> Walls
> Floor
> Ceiling
> Lift motor
> Gear box
> Motor
> Sparks
>
>
> I am sure you get the kinda of idea - any help on this would be
excellent!!
> Thanks Pete
>
>
>
>
>
>
>

that souunds easy but how do you write that as a macro?
if the unique asset number was in column W and the parent asset number for
that asset was in column X

THANKS!!



"Tom Ogilvy" wrote:

> go through the list
> check if there is a parent assest
> if so, insert a cell on the left and place the parent asset name there
> (determined through the unique asset number). On the right end, put in the
> parent assets unique asset number
> continue to do this until you don't have any more assests in the leftmost
> column that have a parent asset.
> remove all the extraneous unique asset numbers from the right side
> sort the data. If you want an indented list, remove parents
>
> Excel only has 65K rows, so 20M will not fit on the sheet.
>
> --
> Regards,
> Tom Ogilvy
>
>
>
>
>
> "Little pete" <[email protected]> wrote in message
> news:[email protected]...
> > Hi
> > I have been tasked with a massive sorting exercise, example below
> >
> > S/S pf a list of assets that each have a unique asset number.
> > Each asset is linked to a Parent asset through the unique asset number.
> > The data dump has not sorted these assets into the hirerarchy view (thats
> > what i have to now do)
> > Need to create either a macro or something to perform this function on
> 100+
> > s/s that have between 50k to 20m of data.
> >
> > example
> >
> > L&E
> > Lifts
> > Lift Car
> > Doors
> > Walls
> > Floor
> > Ceiling
> > Lift motor
> > Gear box
> > Motor
> > Sparks
> >
> >
> > I am sure you get the kinda of idea - any help on this would be
> excellent!!
> > Thanks Pete
> >
> >
> >
> >
> >
> >
> >
>
>
>