Help with Sort!

[chrysti]

I am having huge issues sorting! I am pulling all of my information into a cover sheet so everything is referencing another cells in some form or another, and when I go to sort my information by any given column all of my formulas got nuts, my information doesn't sort correctly and all of my formulas move to refernece the wrong things!!! HELP!!! Why won't my formulas stay put and why does my sheet not sort!!!

Thanks in advance for all of the help!
Chrysti

 

[LxQ]

as to sorting, I would say check whether you're dealing with format issues, such as text or number.. sometimes a number may be a text for Excel.. and sorts differently..

as to references.. depends.. if, for example, you have 10 rows, A1 through A10 and then a sum in A11, after you sort them, if the value in A1 went to A5, then your sum formula in A11 may be referencing A5... so add another row in front of A1 and one after A10, and the formula in A13 should be Sum(A1:A12).. when you sort, make sure you sort only rows 2 through 11... then the formulas will stay..