Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2005
    Location
    Arlington, Massachusetts, USA
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tabs showing sorted views? (Excel 2000)

    Hi. This sounds simple, but I haven't found any examples that do what i'm looking for. I'd like to create a workbook where the user enters rows of data on one worksheet, and then the data shows up in other worksheets in different sorted orders. Help/suggestions appreciated .

  2. #2
    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: Tabs showing sorted views? (Excel 2000)

    One way would be to create code on the worksheet activate to sort a particular way based on the sheet name. Thus whenever those particular sheets would be selected, it would clear the sheet, copy the "master sheet", and sort it as desired.

    If you need additional details, could you elaborate and perhaps give an example sheet and info on the various ways you want it sorted.

    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
  •