Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Sort a Growing Range (Excel XP)

    I have a data sheet that consist of 10 columns. I have buttons at the top of each column that allows me to sort the data by that particular column when needed. No problem!

    But the data list is starting to grow. New entries are being added all the time. The new entries are always added to the end. No rows are being added or deleted. And there are no blank rows...

    Since my sort buttons were based on a "fixed" range, it's obviously not including the newer entries. And I'd rather not re-write the sort buttons every time a new entry is made. How can I work around this? Is it possible to name the range and have the name stick as the range grows? Will the range "see" that new entries are being made and adjust accordingly? Am I barking up the wrong tree?
    - Ricky

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Sort a Growing Range (Excel XP)

    If you have no other data beneath your database why not just sort the entire columns. Any blank rows should be ignored or placed at the end of the data.

    If this is not appropriate, try applying a Dynamic RangeName. See <!post=This post,106607>This post<!/post> by Jan Karl Pieterse for an example.

    Andrew C

Posting Permissions

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