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

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

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

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

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