Totals of different worksheets.

[Pinlaro]

Hi there

Please help. I have 43 different workbooks, each containing 9 named
worksheets ie toys, carrots, flowers and cats containing about 11 columns of
information.

Basically I want the totals of "column B" on worksheet called "toys" in the
43 workbooks added up.

I can put all 43 workbooks on one workbook if thats going to make it easier.
Unfortunately the totals arent all in the same cell.

Any suggestions?

 

[RA]

'[workbook1.xls]Sheet1'!$B$1+'[workbook2.xls]Sheet1'!$B$1+'[workbook3.xls]Sheet1'!$B$1+etc..........

You'd have to do this 43 times but it will work.

 

[Ashish Mathur]

Hi,

It would be a good idea to get all the "Toy" worksheets from the 43
workbooks into one workbook. You may refer to this link to know how you can
do it with Access - http://datapigtechnologies.com/blog/?cat=26

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com