Sort a Pivot Table Based on a Range

[JimmyA]

Hello All

I wonder if someone can tell me if it is possible to sort rows in a pivot table based on a range in the same workbook.

I have the pivot table set up as I need it but the values in the row change each time the macro is run (it is run when new data is added)

As part of the macro a list of Grades is imported into the Workbook. These grades are always imported in the correct order. As such I would like the pivot table to follow the order of imported grade list. The grades in the list will always be the same as the list in the pivot table.

Is this something that would be possible to do?

I hope I have explained well enough what I am trying to do but if not please let me know.

Thank you very much in advance for any suggestions.

Regards

Jim