How to: Macro- Consolidation of data from diferent workbooks with same headers

K

kaitou

New Member
Joined
Sep 18, 2015
Messages
33
Hi everyone,

I am new in using Macro, please assist me on how to consolidate data from different workbooks with same headers.

I'll just only need the data from each workbooks not the headers because I will only have 1 header on the new workbook (consolidated)

Thanks everyone!
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
You must log in or register to reply here.

Similar threads

G
  • Question
Macro to consolidate multiple worksheets into Master based on cell data?
Replies
1
Views
349
bobaol
B
J
  • Question
Consolidate data from multiple sheets based on values selected in dependent list boxes
Replies
0
Views
297
jconda
J
H
  • Question
Extract Data from Single Cell. Column is Constant. Number of Rows Involved Changes. Number of Rows Within a Single Cell Can be 1 Up to 9
Replies
6
Views
162
helpmeplz_
H
H
  • Solved
Consolidate data from selected sheets into master sheet & automatically update data.
Replies
8
Views
770
Joe4
Joe4
M
  • Question
Ideas Power Query and/or Python?
Replies
8
Views
148
mickeystanford_alumni
M

Forum statistics

Threads
1,216,081
Messages
6,128,695
Members
449,464
Latest member
againofsoul

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