consolidate from different files - excel 2010

L

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,805
Office Version
  1. 2016
Platform
  1. Windows
Hi
I remember it is not possible or there is not any command in the ribbon to do consolidation from different files. I had to press 3 keys to get that consolidate window to consolidate from different files. What is the command?
Thank you.
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
You must log in or register to reply here.

Similar threads

Y
  • Question Question
Consolidate all values from specific sheets into 1 master excel file
Replies
1
Views
178
Trebor76
T
A
  • Question Question
Saving dialog box hanging after running macro
2
Replies
16
Views
302
Alex Blakenburg
A
N
  • Solved
Formula to consolidate Data and remove entries with no data in that year
2
Replies
10
Views
350
Newbie73
N
M
  • Question Question
Copy File Names to Destination File
Replies
2
Views
316
metalscuba
M
S
  • Question Question
Consolidate or Similar, Only with Formula Reference?
Replies
0
Views
261
Scotster
S

Forum statistics

Threads
1,223,903
Messages
6,175,289
Members
452,631
Latest member
a_potato

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