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