how to make rows 'sort with' between sheets during separate sorts

[Margo]

What I need to do is perform sorts on any column on either sheet that will
'hold' onto its respective row if linked from one sheet to the other.

IOW some columns on sheet 1 have formulas based on values in sheet 2 and
vice versa. But the columns referenced for values are not the same ie S2A1
has formula based on the value in S1B1, and S1C1 has formula based on the
value in S2C2.

All initial sorts I perform on S1, in any column, any way, carries over fine
to S2 (the first time I perform it), but then when I perform sorts on S2 that
sort doesn't carry back over to S1.

Sorts on both sheets, in several columns, filled with either values or
formulas, need be done a constant basis.

 

[ryguy7272]

I don't know about others, but I'm confused. If you can give somehow give an
actual example, with actual data, I'll try to help you.

Regards,
Ryan--

 

[Margo]

I've uploaded a copy of the spreadsheet here:

http://www.megaupload.com/

What I need to do is be able to perform sorts on Sheet1, then on any column
in Sheet2, and still have the rows hold true when I go back and perform
additional sorts on Sheet1 again. Also, under normal circumstances, any
columns with formulas would be locked and sorts performed via macros.

Thank you very much for any help - it's driving me crazy.

 

[RyGuy]

I can't see the file. Send it to me at: (e-mail address removed)
(remove the xxx).
Regards,
Ryan--

 

[ryguy7272]

Sorry to take it offline, but I couldn't really understand what was needed.
Anyway, for those following this post, the issue was resolved with this
function:
=INDEX($A$1:$A$10,MATCH(ROW(A1),COUNTIF($A$1:$A$10,"<="&$A$1:$A$10),))
Ctrl+Shift+Enter

This 'alphabetizes' the array.
Ryan--