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" wrote in message
...
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" wrote in message
...
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