sorting problem w/ pivot table

Hi all,

I am trying to make a pivot table, and I wanted to sort by values instead of the row labels. The sorting seems to work for the most part, but a couple of entries seem to be off. I have attached the file, and I hope that someone will be able to help me.

In the DATA tab, it has the information I wanted to make into a pivot table. In the TABLE tab, it's the result of some macro written to display the pivot table. I've highlighted the 2 entries I believe to be not sorted correctly in this table. Row label "16D" and "17F" need to be farther down the list.

For instance, "16D" should be above "17A", and "17F" should just be the last row of the table. I am not sure why the sorting function is weird. Also, please check out the VBA code to see if I did anything wrong.

Thanks in advance!!

If I sort the table manualy I get the right result.

See the attached file.

Please Login or Register  to view this content.

Probably the failure is on this row.

You don't select the whole table for sorting, so column A will be not sorted that way.

I get an faillure on this row if I want to run your macro.

Please Login or Register  to view this content.

You have to define which "begin" => you got 4 of them, needs to be sorted and in which order.

That also affects the sorting in column A.

Please Login or Register  to view this content.

That is what will be done.

But thats why i ask you wich begin has to be sorted.

1) Just the first

2) of all the colums with begin

3) and in what order they need to be sorted.

That's a general question (it has nothting to do with the pivot table solution) which you have to answer, before you can test if the values are sorted well.

And if you do that manualy, how the data in column A are sorted?