Combine Data from Multiple Sheets into One Sheet When Your Columns are Different (Or Out Of Order)

Need to combine Sheets where the columns are different or out of order? Not a problem y'all!

[datageekhub]

Dan, I just want to thank you for your excellent code to make my life so easy! I recently need to handle a lot of data, I tried different code, only yours work for my visualization project! Just don't know how to thank more to you! Bro, you are amazing! It save me tons of time! The beauty of the code make the project so easy!!!


BIG respect to you!!!

[kentjonakurtaj]

Hi Dan, Many thanks for your code. It worked perfectly with the data that I had. If u can help with a question that I have will be great. The code works only if I have everything else closed otherwise it will combine all the data together. Do u have any idea how can I define the worksheet on which code must run? I can name a spreadsheet for example by date and I want the code to run only on that spreadsheet. It's a daily report that I have to automate, your help will be much appreciated.

[kristjanminnatharmet]

Thanks for this! I added a loop and a query and easily converted and combined entire folder of files in to a single table.

[immyftw]

This is fantastic, thank you! Quick question: what would I add so that this ignores both hidden columns and hidden rows?

[gokulakrishnansubramaniam]

Can we get data in same line based on unique values

[pierreobrian]

Hi Dan, do you have any tutorials to merge specific column headers from different workbooks?

[deegovang]

Hi Dan. This sheet works perfectly. And your Public Sub 'Combine Sheets With Different Headers works perfectly, too. I'd like to be able to combine data from multiple sheets into one AND exclude three sheets, such as the dashboard, etc, so I examined both subs to come up with a successful compilation of the two. I have failed. Would you please tell me how to exclude certain sheets. Thank you!

[prudwiraj]

Hi Dan,

Could you modify the code if i want to combine the data from different workbooks?

Thanks
Raj

[prishamadhotra]

Hi Dan, Do you have similar presentation for consolidating workbooks ?

[SolidBuildersInc]

Hey Dan, I have been working on your approach for a while and I am trying to use it against an Alias Header Table. This Table will house all the alias names of a Header and will update to the Alias Header in this Table if found in the Range of Headers. Do you have a suggestion of how to incorporate this methodology into your code?  It essentially does exactly what you are doing, but allows for Headers to be updated to reflect the Header used in the Alias Header Table instead of just the Headers that are in the multiple sheets being combined. This way, if you have 3 sheets and they have different formats for (First_Name), for ex. (F.Name, F-Name, FirstName), They will all get compared to the Alias Header Table which lists these 3 ways of expressing First_Name under the respective column in this case (First_Name) and the data would get executed because the name for that column was found. I hope this makes sense.

[arabellemendoza]

Hi +Dan Wagner. I am currently working on combining the data from different worksheets and I found this tutorial video very useful. However, I am encountering an error message "user-defined type not defined". I can't seem to find the Microsoft Scripting Runtime in the options. Do you have any suggestion for this one? Your assistance is greatly appreciated. Thank you

[josephcadelina]

How should it be modified if I had to skip some of the worksheets? Would hiding the worksheets do the trick?

[sameerjadhav]

do we need to add any reference from library? bcoz m getting debug that sub or function not defined at "LastOccupiedColNum"... please help .

[thushanwaruna]

very nice but I got below error
"user-defined type not defined"

[marcellanance]

Dan, I'm not an Analyst. I've taken a couple courses but it's been years ago! I'm now "Popcorn Kernel" for my son's cubscout pack and it's a rather larger group. I'm trying to make a totals sheet for the pack, one sheet for each of the age groups (Tigers, Wolfs, Bears, Web1 and Web2) and a sheet for each individual scout.

What I would like is to put the detailed info into each scouts sheet, and have it populate and total on the age group sheet and the pack sheet (I can handle sums on the individual sheet but across worksheets, I get lost). Can you help me? I would be happy to send you what I have. We have about 60 scouts total and they are all selling 3 different ways (in store fronts, door to door, and online) and I'm giving out prizes for the top sellers each week, by age, and overall, and I need to keep track of it all without going insane. We are selling through mid Oct but sales started on 8/26 so I'm already falling behind on data entry! Please help!!!