+ Reply to Thread
Results 1 to 2 of 2

Re-sort table without affecting original table?

  1. #1
    Registered User
    Join Date
    09-29-2010
    Location
    Portland, OR
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re-sort table without affecting original table?

    Is there a way to re-sort a table of data on another worksheet without affecting original table?

    Let's see if I can explain this clearly.....

    I have an excel table with a list of CD's in my library, including the purchase date. I have the table sorted alphabetically.

    I would like to - on a separate worksheet - sort them by purchase date. I know I can copy the data and sort it, but I was wondering if there was a way that it could happen automatically. i.e., if I add a new CD to worksheet 1, worksheet 2 gets updated (and sorted) automatically.

    Any thoughts?

    John

    P.S. - Excel 2010

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Re-sort table without affecting original table?

    What if you set up 2 sorting schemes on the same data: one by title, the other by purchase date to you can toggle between them.

+ Reply to Thread

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