Home |
Search |
Today's Posts |
#1
|
|||
|
|||
links between list
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) |
#2
|
|||
|
|||
links between list
does that mean that it is impossible please give an answer
"gilles boudreau" wrote in message ... 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) |
#3
|
|||
|
|||
links between list
I don't know what a "line of travel" is.
Your example did not make it very clear how the data was organised or related, since the names in the one list were different from the names in the other. Generally it is not sensible to try to maintain two separate but equivalent lists in Excel. Specifically: 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 If you used a formula in the alphabetical list you could pick up a number from the other list that corresponds to the same name, if the name only occurs once in that other list. (See VLOOKUP or since it looks like the numbers come before the names, INDEX and MATCH) b) and also if i need to delete a line it would delete the corresponding line in the other list. No - unless you were to write a macro to do the deletions from both lists. c) would that be possible on the same sheet or even different sheets of the same file No more easy on same sheet or different sheets. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I MAKE VALIDATION LIST CONTAING DATA FROM A DIFFERENT BO | Excel Discussion (Misc queries) | |||
Copying list item (a bit less vague) | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Is there a way to create a drop-down list of links in Excel? | Excel Worksheet Functions | |||
print a list of worksheets and links | Excel Worksheet Functions |