First of all thanks for your script and welcome back.
I am sorry but i have to request this last and final issue. I have 1 more addition request this will solve my sorting issuing. I have added 11 option buttons. Here are the details for my request.
If I select checkbox1 and select option button 3 then option button 8 then option button 10 the report will be generated and sort by the selection.
For Example: The generated list will be sort by first class i.e. VIP+, VIP, A, B, C+ & C then sort by Region then sort by City. If the sheets are more than 1 then same condition will be applied to all the sheets. I hope you have understood what I want. The sorting will change according to the selection. I have attached entire network and all sheets have been sort by Class first then Region and then City as selected in frame 8.
Note: The user should receive error message is he select same selection more than 1 frame.
For Example: He Class Then City Then City.
If you have any doubt please ask me before you start. I don't want you to kill your self by keep changing the script.
Sample file is attached for your more clarification.
Bookmarks