Totals of different worksheets.

  • Thread starter Thread starter Pinlaro
  • Start date Start date
P

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?
 
'[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.
 
Back
Top