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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
You must log in or register to reply here.

Similar threads

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

Forum statistics

Threads
1,214,386
Messages
6,119,220
Members
448,876
Latest member
Solitario

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