Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
collecting data from many sheets to one sheet | Excel Discussion (Misc queries) | |||
Data from two sheets make up a list in a third sheet (real time) | Excel Worksheet Functions | |||
macro | Excel Discussion (Misc queries) | |||
Combining data from cells from several excel sheets to a new sheet | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |