Reformatting with macros

[mille1sj]

Hello Everyone,

I am a novice macro user, I can usually fumble my way through macros with the assistance of searches here on the forum, but I have now got in a little over my head. I have attached an example of my raw data (Model A and Model B tabs) and a small exaple of the finished product (Combined Data Tab). I need to move each data source (1-11) to the combined tab and reformat it to allow me to make pivot tables. I have been doing this manually and have found this to be very time consuming. I am trying to take teh model A tab and reformat it to look like the Combined Data tab, after that is complete, I then want to move the Model B tab and refort adding the data to the Combined Data Tab. The number of rows in in Model A and Model B are not a set amount, they may change, the problem descriptions may also change.

My reason for wanting the data in the format is to allow me to create pivot tables and charts from this data that will allow me to create specific paretos.

Raw Data Test 9-13-13v2.xlsx
Any help would be greatly appreciated!

[jaslake]

Hi mille1sj

This Code is in the attached and appears to do as you require

Please Login or Register  to view this content.

[mille1sj]

This worked perfect, i made a few changes to rename the columns and added a few additional tabs to include in the combined tab. Thank you so much for your help!!!

[jaslake]

Hi mille1sj

You're welcome...glad I could help.

If this resolves your issue please mark your Thread as SOLVED.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save