Solved

# Excel sort

Posted on 2011-10-07

Hello,

I'm stuck on an excel problem... I know what to do I just don't know how to do it.

so here is my problem.

I have a table of about 800 rows.

something like this

__PartNumber__ __Location__ __NewLocation__

PartA L09 R9

PartB L08 Q3

PartC K1 R38

I need to sort this spreadshet in such a way that if the first row has new location as R9 then the next row will have Location as R9.... and whatever the newLocation for that part is, it will be the Location for the following row (part)

so that my table will be sorted such as this

__PartNumber__ __Location__ __NewLocation__

PartA L09 R9

PartB R9 P3

PartC P3 G3

We're moving a few parts around in our department, so if I pull out a part out of lets say location 09 and the new location is R9, i now need to know where the new location for part R9 would be...... Is there a query/macro that I can run.. can someone help me out.. I have no idea how to accomplish this...

thank you

PS.... I'm using excel2007