Results 1 to 2 of 2

Thread: Keeping Data Alphabetized After Refreshing

  1. #1
    Acolyte rosetc16's Avatar
    Join Date
    Apr 2017
    Posts
    43
    Articles
    0
    Excel Version
    Excel 2016

    Keeping Data Alphabetized After Refreshing



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all,

    So I have a pivot table that has a list of names that I refresh on a regular basis. I want the names alphabetized, but when I add a name to the list and then refresh, it just places the name at the bottom of the list. How can I ensure the name get refreshed into the correct location? Thank you!

  2. #2
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    312
    Articles
    0
    Excel Version
    2007
    .
    Referring to this resource ( https://www.techonthenet.com/excel/f...sort1_2007.php ), you can record a macro of your actions to create a macro code.

    Difficult to advise more specifically without having your workbook to refer to.

Posting Permissions

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