Sorting Members by Multiple Properties

[Former Member]

Hi there,

Is there a way of sorting members by multiple properties?

Regards,

Cagri.

[Former Member · Accepted solution]

Hi,

I solved the issue by making use of "Record Macro" functionality of Excel. I have had my data sorted through "Sort" function under "Data" ribbon, and have it recorded as a macro.

In order to prevent sorted list getting spoiled every time the input report is refreshed, I created a form button and added a macro in it with "SaveAndRefreshWorksheetData" FPMXL function.

Regards,

Cagri.