reorder/sort worksheet tabs

stargazer · Apr 6th, 2002, 09:25 AM

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 · Apr 6th, 2002, 10:09 AM

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 · Apr 6th, 2002, 02:06 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 6th, 2002, 09:25 AM	#1
stargazer New Member Join Date: Mar 2002 Location: Weathersfield,VT Posts: 18	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

Apr 6th, 2002, 10:09 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	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

Apr 6th, 2002, 02:06 PM	#3
stargazer New Member Join Date: Mar 2002 Location: Weathersfield,VT Posts: 18	Dan, Thanks very much. That code did the job well. Bob