I work for a company with a number of distribution centers (DC's) in different cities. When we add a new DC or division all the row numbers change. I then do a match to find the new row numbers. Is there a way to highlight the range B2 to B5 and change the row numbers based on the match formula in C2 to C5.

               Row      
=City!B3      1        
=City!B1      2
=City!B4      3
=City!B2      4

End Result
=City!B1
=City!B2
=City!B3
=City!B4
The formula will remain in B2 to B5.

Sean

Sounds like you are asking how to use an Excel feature.

Highlight the rows to be sorted, use the Data Sort feature with sorting with "Row" as top priority, ascending order and that's it.

If this is not what you're after, please provide more details.

____________________________
Knowledge is there to share, not to hide!
-< PATKAM >-