MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


Posted by mseyf on March 29, 2001 5:16 AM

you could try to insert a column, copy the formulas, paste as values into the new column, sort the range based on the new column, then delete the new column.
Seems like there should be an easier way, but I don't know what it is.