I have workbook with 250 sheets and I need to sort them by the total sales on
each sheet.

My first thought was to rename the sheet to the sales value (e.g. Customer
ABC111 had sales of $4,000, so the worksheet name is now 4000). That part
worked fine, but when I use any sorting code, it sorts the sheets in the
alpha code (1,11,111,2,22,222, ect).

Is there a way to sort these sheets numerically?

Thanks!

PJ
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.