Hi


I have two worksheets, List and Quotes. The first two columns of both are linked ==> i.e., cell A1 in Quotes contains =List!A2, B1 contains =List!B2, etc. (It is A2 ... because List has a header row and Quotes hasn't). What I wanted to achieve is to simplify matters. Should I need to sort the values in List, the identical values in Quotes would automatically change too.


However, instead it has added a snag. The values in the C-columns in both worksheets are different but the ones in Quotes would need to stay with their respective cousins in A and B columns when they change positions when things change in List. Obviously, I cannot just enter =List!C2 in the column in Quotes so is there a way to do this, i.e. link different values?