Sum Multiple Books

A

AllDay

New Member
Joined
Jul 28, 2016
Messages
12
I have 200 Workbooks in one centralized folder. Each Workbook has 10 Sheets. Each Sheet is Identical throughout the entire workbook so there is no mixing and matching required.

Is it possible to sum all 200 workbooks and generate one workbook of 10 sheets?

TIA
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
You must log in or register to reply here.

Similar threads

C
  • Question
Multiple Workbooks to one.
2
Replies
11
Views
579
dmt32
D
G
  • Question
Open workbooks in folder and run Macro in each book
Replies
7
Views
386
glynn1969
G
S
  • Question
VBA Challenge
Replies
2
Views
256
SnowyBry
S
C
  • Question
Copy and paste data through multiple workbooks
Replies
2
Views
212
CDaviess
C
W
  • Question
Sheet that updates by referencing cells in workbooks located in separate folders on shared drive
Replies
0
Views
157
Woodpusher147
W

Forum statistics

Threads
1,215,206
Messages
6,123,636
Members
449,109
Latest member
Sebas8956

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top