You could always, in a third column...

=A1&B1

... copy down. Select column, Ctrl + C, Alt + E, S, V.

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.



"tigercat73" wrote in message
...
I'm trying to find a way to keep data in two columns matched. Say in
Column A
I have loan #'s and in column B I have dates. I'm trying to find a way to
keep the entered data permanently "married" in relationship to each other.
So
if I sort column A descending, the dates will move with the proper number.
I
know this can be done if both columns are highlighted and column A is
sorted,
but if only A is selected, the dates in B will not change with the
corresponding loan number. This would keep from making a really time
consuming mistake.
Is there a way to do this.
Thanks
Dan