Nel post
*Rachael-R* ha scritto:

I basically have 5 worksheets that I enter data - formulas are set
for each row and are different for each. The value I get for the
formula is then transferred to a summary sheet. But if I sort any
one of the 5 data sheets my formulas get all screwed up. Plus if I
have to add or delete any rows the formulas again get screwed up. Is
there any way to lock in the formulas. I tried protecting but that
doesn't seem to do it. Help!

Hi Rachel,

What do you mean with "screwed up"?
Maybe you have some empy column beetwen the data you sort and the zone with
formulas: for a good sorting you need no empty row/column in your list.


--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy