Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
complex column sorting
I have a workbook with several sheets that referece a data sheet. If
I change the sort on the data sheet the other (referencing) sheets fail to "follow" the change. The refering sheets now contain different values b/c they point to the old (prior to sorting) cell location of the data sheet. I understand that Lotus handles this operation natively (without coding). Can it be done in Excel too? I'm sure it can be done by coding but since Lotus can do it natively, I wonder if Excel can too? Thank you, John Wilson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting complex worksheets | Excel Worksheet Functions | |||
Formula or macro needed for sorting complex data issue. | Excel Discussion (Misc queries) | |||
Complex Array sorting issue | Excel Worksheet Functions | |||
Complex Sorting | Excel Discussion (Misc queries) | |||
Complex Sorting Problem | Excel Worksheet Functions |