View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
R3dD0g R3dD0g is offline
external usenet poster
 
Posts: 3
Default Sort worksheets by cell content

I'm not much of an Excel person, I'm more comfortable in SQL & VB.Net.

I have a workbook with sheets of various scores, and an overal score
averaged & summed into a single cell. I would like to arrange the worksheets
in descending order based upon the contents of cell G13.

I've looked at Pearson's sorting based on the sheet name but I don't know
how to extend it to sorting on a single cell. Any ideas?

Thanks for your time.