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. |
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) |