Results 1 to 15 of 15

Automatically Sorting a referenced sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-28-2004
    Location
    Tokyo
    MS-Off Ver
    Office 2016 pro plus
    Posts
    175

    Automatically Sorting a referenced sheet

    I have a dorm roster on one sheet and the other sheet is an Alpha Roster. I want it to automatically sort alphabetically (column B) . Any time I change the roster, the Alpha Roster sheet doesn't automatically sort, I have to hilight and re-sort it again.

    I updated the file, there are 4 tabs at the bottom. 1st Floor, 2nd Floor, and 3rd Floor. I want to have all the names, room numbers, and phases (ph) in alphabetical order on the Alpha roster tab. And when ever I make changes to one of the Floors, it will automatically update it the Alpha Roster.
    Attached Files Attached Files
    Last edited by skylinekiller; 02-18-2009 at 09:34 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1