Create Headers and list values

[Jaypelt]

I have attached a file of an example of something I trying to do. Been so long since I have used VBA I have been getting nowhere. Basically I have a column with headers, I want to pull one instance of the header then the corresponding rows in col A and B where col C is the same header. Any help would be greatly appreciated.

[jindon]

Delete 1st row then run the code.

Please Login or Register  to view this content.

[jindon]

If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED.

[MarvinP]

Hi Jay,

You can get your result without using VBA. A Pivot Table can do what you want. See the attached.
NameTest Pivot Table.xlsx

[Jaypelt]

No a pivot table is not desired here. The example I gave is pretty basic, the end product will have further calcs and what not. The sort was just for setting up the larger need.

[Jaypelt]

Is there a limitation to the amount of columns I can have in 'x'? When I add more I get a type mismatch error.

[Jaypelt]

here is a new file with how it actually looks and what I want to do. In the live data there seems to be something blocking while I get something close in the TEST file. Sheet1 is the macro output, desired is what i want to do.

[jindon]

Now you are asking completely different question.

Please Login or Register  to view this content.

[Jaypelt]

Sorry, there was an unknown extra. Appreciate the perfect the solution.