Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: reorder/sort worksheet tabs

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Weathersfield,VT
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,940
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Weathersfield,VT
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •