Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    May 2003
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sort tabs (Excel 2000 SP-1)

    How can I sort the sheet tabs in my workbook?

    Thanks,
    Linda

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort tabs (Excel 2000 SP-1)

    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort tabs (Excel 2000 SP-1)

    Great minds....

    Perfect timing Steve!
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sort tabs (Excel 2000 SP-1)

    <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15>I was within seconds of posting the same link as Jan Karel and the one you no doubt meant to post.

  5. #5
    New Lounger
    Join Date
    May 2003
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort tabs (Excel 2000 SP-1)

    Gee...thanks everyone. Are you certain I can't just click a couple of buttons!? <G> I will try this soon and be back if I need help. I have pasted macro's in word with step by step instruction but haven't tried excel yet.

    Linda

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Sort tabs (Excel 2000 SP-1)


  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Sort tabs (Excel 2000 SP-1)

    I had an extra dblquote which screwed it up.
    I fixed it.

    Steve

Posting Permissions

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