link between lists

[Guest]

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)

 

[TaurArian [MVP]]

Perhaps a Newsgroups for Excel:- (OE clients)
news://msnews.microsoft.com/microsoft.public.excel
news://msnews.microsoft.com/microsoft.public.excel.misc
news://msnews.microsoft.com/microsoft.public.excel.newusers
news://msnews.microsoft.com/microsoft.public.excel.setup
news://msnews.microsoft.com/microsoft.public.excel.programming
news://msnews.microsoft.com/microsoft.public.excel.worksheet.functions