link between list on same sheet
 

i have excel 2002 and i am creating two lists of name one line of travel and
one alphabetical. I want to know if there is a way to link the two together
in a way that if i change the sequence number on the travel one it will
automatically change the number to the corresponding name in the
alphabetical list of name

5 - BRAS, Carlos (11020)
6 - BURDICK, Daniel , Christine (11030)
7 - LINDSAY, John, Jan (11040)

~ B ~
27 - BLAKE, Millmine (MAY) (6) (site 2) RR1
18 - BOUFFARD, Rene (MAR) RR1
21 - BOURKES LOCAL ROADS BOARD (NOV) RR1



--
XP home , Office 97

any or all responses are gratefully accepted and thank you for your time

Running Compaq P3, 500Mhz
WIN XP home, Office XP SB
Dialup (no choice here)