Excel VBA Tips n Tricks #15 Converting Jumbled Data to WORKABLE Data for Reporting

We're taking a typical set of data with multiple columns and setting them into a database format that has a record for each piece of data. This way a pivot table can understand our data to total things correctly.

Check it out!

Fantastic Developer Tools:

[Hodan]

hi Dan,
Its Stefan - thank you so much. I have to say - you literally save my weekends. You have to see the smile on my face right now :)

[krn]

Wow, this is great. I can adapt what u have shown here to turn a bunch of my raw data into useable data. Thanks Daniel.

[ExcelVbaIsFun]

I'm glad you can use this info!! Thanks!
Dan

[shlerTHEnumbas]

Dan!! After watching all of your videos up to this point I have to say you are awesome!! Thanks for putting this out there for us. I think it would be great if you could list the code for the video you are working on in the videos description. You are doing an awesome job, but when you move from one piece of code to another sometimes I get a little lost. I am still just a beginner....

Keep up the good work.

[ExcelVbaIsFun]

Thanks RicksGAFaves. You're probably right. Have a great day! Dan

[alexxgalaxy]

Hi Dan. The codes were so cool! But I noticed something seemed to go wrong with the EAN on E3:E14 on the idsheet. Why wouldn't they turn into text like the rest?

[teajaeb]

Hi Daniel,

I've been using VBA for a couple of years now, and I've been wondering about looking for a new job that suits my VBA skills, or maybe working as a freelance VBA specialist.

Would you be able to help me value my skills in terms of a job market salary or freelance fee if, say, I were capable of producing the work of this video?

Thanks for your help, and thanks for all of these videos that help me to learn VBA!

[JS-ysuk]

Watching 6 years later and I'm very grateful for Power Query! LOL

[ExcelVbaIsFun]

Just uploaded a video that explains how to download my latest workbook. I'm working towards uploading the rest.

[ExcelVbaIsFun]

I can see how that would be a problem. . . My typical solution for this is sharing my Dropbox link, which contains all my wbs that I display on the vids. Apparently I haven't retro-fitted all the video descriptions with that dropbox link. Will do. Anyway this just enables people to download all the old and new wbs FREE. If you share my folder in your dropbox account, every new addition I make will auto-download to your folder. Dan

[mehmetcanbulat]

Hi Dan,
How can i download the excel file?