Shariq, you're using Absolute addressing for cell M4. Take out the $ and you
should be able to copy down with no problem. HTH
--
Sincerely, Michael Colvin


"Shariq" wrote:

I'd like to merge the data of several books infact 12 each for a month, and
each book contains 4 to 5 sheets these have to be collected on a singel
sheet, as a final review and comparision for the whole year I've been doing
this by adding up in

=SUM('[08 AUGUST 2006.xls]A'!$M$4;'[08 AUGUST 2006.xls]B'!$M$4;'[08 AUGUST
2006.xls]C'!$M$4;'[08 AUGUST 2006.xls]D'!$M$4)
but this takes for ever, to copy each and singel cell. And if I double
click the cell to copy down it copies the infomation in M4 al the way down,
so is there any other way to handel this problem, please help.
Shariq