reorder/sort worksheet tabs

[stargazer]

I'd appreciate knowing how to reorder the sequence of worksheets in the workbook. I know how to drag and drop, but I have a lot of worksheets and am adding more as I use the workbook. Is there a way to sort alphabetically, or other bases for grouping them? Also, I know I can mess up 3D references by moving sheets, but would like to select particular records/sheets to sort, without damaging important formula bearing sheets. Thanks very much. Bob

 

[dk]

Hi,

Try here for a macro which sorts worksheets in ascending or descending alphabetical order.

http://www.cpearson.com/excel/sortws.htm

If you move the location of the sheets the references will be fine - the link is not dependant on the physical location of the sheet within your workbook.

HTH,
Dan

 

[stargazer]

Dan, Thanks very much. That code did the job well. Bob