Ok here goes, I have a number of sheets in one book.
What I need to do is - in sheets 1 to 10 I need to do a sort, then in sheets 11 to 20 which are linked to sheets 1 to 10 I need to sort also.
If I sort sheets 1 to 10 there fine, but, when I go to sort sheets 11 to 20 because they are linked to the first 10 sheets it doesn't sort right.
For example in sheet 11 cell G4 is linked to sheet 6 cell F16, but because I have sorted the information in sheet 6 it does not tie in with the information that was previously in row 16 as that information is now in row 4. How can I sort sheet 11 so that the information relates to the information that is now in row 4 of sheet 6?
Hope I have explained this OK!
What I need to do is - in sheets 1 to 10 I need to do a sort, then in sheets 11 to 20 which are linked to sheets 1 to 10 I need to sort also.
If I sort sheets 1 to 10 there fine, but, when I go to sort sheets 11 to 20 because they are linked to the first 10 sheets it doesn't sort right.
For example in sheet 11 cell G4 is linked to sheet 6 cell F16, but because I have sorted the information in sheet 6 it does not tie in with the information that was previously in row 16 as that information is now in row 4. How can I sort sheet 11 so that the information relates to the information that is now in row 4 of sheet 6?
Hope I have explained this OK!