Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
Update links prompt not wanted | Excel Discussion (Misc queries) | |||
Reoccurring Edit Links Error | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) | |||
Links in Excel | Excel Discussion (Misc queries) |