totaling across 30+ workbooks

[sgtwilko]

I have 30+ workbooks that I need to summarise the data from. The format of each workbook is the same and the data I need to total is on the second sheet. I need to get a total for 50 items from the 30+ workbooks in order to cost the job. Any suggestions on the easiest way to do this would be appreciated.

 

[Biz]

Hi,

I have used RDBMerge Add-in which required no VBA coding. May save lots of time too!

Try weblink below
http://www.rondebruin.nl/merge.htm

Biz

 

[Capt_Ron]

If the data arrangement is uniform among the 30+ sheets, you might try 3D formulas to sum the data from many sheets onto a summary sheet.

Ron

 

[Biz]

Try weblink below

http://www.mrexcel.com/forum/showthread.php?t=119020

Biz

 

[sgtwilko]

Evening.

Thanks for the replies. I've linked all the workbooks into a new summary workbook and used 3D formulas to get the totals I need. I tried the RDBmerge add in, wasn't the best option this time but will be useful in the future.