Posted by George on March 05, 2001 1:31 PM
I have a worksheet w/part numbers and part names in 9 different columns, A-I.
The way I have it now, the data in columns B-I correspond to the number in Column A.
I am trying to sort the data so that I may lookup any number or name and still
have the rest of the data correspond to each other.
For example, in the data below, the number/names in column B-E correspond to the
Master Number in column A. Let's say that I wanted to sort the data by component name
(column D) or component number(column E), and still have the data in the other
columns correspond to these names/numbers. I hope this is clear enough for you.
Thanks in advance!
A B C D E
Master Number Assembly number Code Name Component Name Component #
1234 567 xyz bolt 891
4321 856 abc bolt 426