thanks for the help dominicb.
i tried this with several files and I got sums of the fields. But
unfortunately I lost all formulas. Actually not a big problem coz I can
update it. The problem I have is that your method only works if all fields
are unlocked or all fields are locked. The other way to do it (Data --
Consolidate) works better for me at the moment, and i find it easier to
handle (just a couple of clicks) but in the end it's the same function I
guess. With both ways, I'm loosing all formulas and the text describing the
content of the cells...

"dominicb" wrote:


Good afternoon Chris Confused

You could use an array formula.

Highlight the range on your master sheet where you expect the values of
the formuale to go. Press "=" and then highlight your range on your
first source sheet (which must be the same size), press "+" and
highlight the range on your second source sheet, and so on. When your
formula is complete press ctrl + shift + enter to commit it.

It's a bit tricky to describe well, but try it - I think it will do
what you want and it's quicker than doing it cell by cell.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=386746