Not and have the reference move/follow to the new location. You would need
to use a vlookup as the reference in the different location to "find" the
referenced value if that is possible.

--
Regards,
Tom Ogilvy

jimmy wrote in message
...
Is there any way to sort the information in a column of
cells that are all referenced from a different location?
thanks a lot