sort block of formulas
Posted by adam k on March 28, 2001 3:20 PM
i have a block of data that are formula referencing data on other sheets. In autocalc mode, I try to sort the records, manually or through code and it sorts for a second and goes back to its original state. If i leave it on manual calc it works fine. Because the info is updating i need to keep it on autocalc. IS there any one who know how to fix this problem. Most of the formulas are using the index and match functions.