Array and sum under headers

[Giake]

Hello,

All values in row A and B come from a csv file that can be totally different, short or long, this mean that my headers C2, D2, E2,… also change from 5 till sometime 250 to the right.

When I push ‘Sort’ VBA make from the unique values in column B my headers in column C2, D2, E2, F2, G2,… and sort the correspondent values under the correct headers/titles.

For realize all above I use column K but my question is now; can I put the values in an array so I don’t need no more to work with column K?
The next question is; how can I have automatically the sum of rows C, D, E, F, G,…. above or under the headers/titles.

Thank you very much to read this!

Greetings from Giake

[Marcol]

You coluld do this without VBa and Buttons.

Drag C2 across as far as you reasonably expect your data to require, and a bit more for luck.

Please Login or Register  to view this content.

Then in C3 this CSE Array, this must be confirmed with Ctrl+Shift+Enter not just Enter, before dragging across and down.

Please Login or Register  to view this content.

[Giake]

Thank you very much Marcol, you are very smart!
this work like a charm