Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to make rows 'sort with' between sheets during separate sorts
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to make rows 'sort with' between sheets during separate sorts
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-- -- RyGuy "Margo" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to make rows 'sort with' between sheets during separate so
I've uploaded a copy of the spreadsheet he
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. "ryguy7272" wrote: 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-- -- RyGuy "Margo" wrote: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to make rows 'sort with' between sheets during separate so
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-- -- RyGuy "RyGuy" wrote: I can't see the file. Send it to me at: (remove the xxx). Regards, Ryan-- "Margo" wrote: I've uploaded a copy of the spreadsheet he 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. "ryguy7272" wrote: 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-- -- RyGuy "Margo" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a column of data sort into rows? | Excel Worksheet Functions | |||
How to I sort in 2 worsheets where an unlinked column sorts as wel | Excel Discussion (Misc queries) | |||
same range, multiple sheets, different sorts, help please! | Excel Worksheet Functions | |||
sort in excel that sorts digikey | Excel Worksheet Functions | |||
How do I make the sort default to 'No header rows' | Excel Discussion (Misc queries) |