Mate,

I have this same problem. It's killing me. How did you resolve it in the end?

I have names typed in Col A, then a bunch of formula's in rows B-Z which bring data from other sheets using the Col A data as lookup reference for sumif formula.

I have all sheet filtered. But when I sort by a column it sorts so that my formula in row 5 now looks at the Col A data in say row 97. I want these formula's in Col B-Z to stay referencing to the row they are in no matter how I sort.

Does this make sense? Any suggestions greatly appreciated.

Thanks,
Flano..