Totals of different worksheets.
 

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?

Totals of different worksheets.
 

'[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.

"Pinlaro" wrote:

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?

Totals of different worksheets.
 

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

"Pinlaro" wrote in message
...
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?