Collect data of several sheets on another book's singel sheet
 

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

Collect data of several sheets on another book's singel sheet
 

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