links between lists
 

i have excel 2002 and Win XP. I am creating two lists of name one line of
travel and one alphabetical. I want to know if there is a way
a) 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
b) and also if i need to delete a line it would delete the corresponding
line in the other list.
c) would that be possible on the same sheet or even different sheets of the
same file
That would be fantistic but may be i am dreaming too much. Let's hope for help
line of travel list
5 - BRAS, Carlos (11020)
6 - BURDICK, Daniel , Christine (11030)
7 - LINDSAY, John, Jan (11040)


alphalist
~ 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)