+ Reply to Thread
Results 1 to 7 of 7

How do I copy data to end tab and have it appear sorted?

  1. #1
    Registered User
    Join Date
    10-17-2011
    Location
    TX
    MS-Off Ver
    MS Home and Office 2019
    Posts
    10

    How do I copy data to end tab and have it appear sorted?

    The title should read "2nd tab" not "end tab....I don't know how to correct the title. SORRY.
    _________________________
    Hello,
    I'm trying to write a formula that automatically copies data from one tab to a specific range on the next tab, and appear in alphabetical order even though it wasn't that way on the first tab.
    The data that I want copied is in the second column, but which gets copied depends on the info in the first column A. So in the first tab, it looks like this...

    COL A COL B
    1 nillusory
    2 proliferate
    3 zany
    1 inexplicable
    1 cinnamic
    1 nonprofessorial
    1 timber
    4 engender
    1 busiest

    and in the second tab (say Group 1 tab), I need it to look like this (grp 1 only arranged alphabetically):

    COL A
    busiest
    cinnamic
    inexplicable
    nillusory
    nonprofessorial
    timber

    The first tab is going to be modified by other people, so I need for the second tab to adjust correctly as they put in new words, or delete them.

    THANK YOU SO MUCH!

    I've attached a little example file...
    Attached Files Attached Files
    Last edited by Mae Stoll; 03-03-2015 at 06:17 PM. Reason: mistake in question title

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,366

    Re: How do I copy data to end tab and have it appear sorted?

    Perhaps something like this? pls check this out...using array formulas


    regards
    Attached Files Attached Files

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: How do I copy data to end tab and have it appear sorted?

    Try this...

    Data Range
    A
    B
    C
    D
    1
    ------
    ------
    ------
    ------
    2
    1
    nillusory
    busiest
    3
    2
    proliferate
    cinnamic
    4
    3
    zany
    inexplicable
    5
    1
    inexplicable
    nillusory
    6
    1
    cinnamic
    nonprofessorial
    7
    1
    nonprofessorial
    timber
    8
    1
    timber
    9
    4
    engender
    10
    1
    busiest


    This array formula** entered in D2:

    =IFERROR(INDEX(B$2:B$10,MATCH(SMALL(IF(A$2:A$10=1,COUNTIF(B$2:B$10,"<"&B$2:B$10)),ROWS(D$2:D2)),COUNTIF(B$2:B$10,"<"&B$2:B$10),0)),"")

    ** array formulas need to be entered using the key
    combination of CTRL,SHIFT,ENTER (not just ENTER).
    Hold down both the CTRL key and the SHIFT key
    then hit ENTER.

    Copy down until you get blanks.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    10-17-2011
    Location
    TX
    MS-Off Ver
    MS Home and Office 2019
    Posts
    10

    Re: How do I copy data to end tab and have it appear sorted?

    OH MY!!!! This is EXACTLY, PRECISELY what I was looking for! THANK YOU SOOOOOO MUCH Tony - you saved me hours, no, days of research!

  5. #5
    Registered User
    Join Date
    10-17-2011
    Location
    TX
    MS-Off Ver
    MS Home and Office 2019
    Posts
    10

    Re: How do I copy data to end tab and have it appear sorted?

    OH MY!!!! This is EXACTLY, PRECISELY what I was looking for! THANK YOU SOOOOOO MUCH Azumi- you saved me hours, no, days of research!

  6. #6
    Registered User
    Join Date
    10-17-2011
    Location
    TX
    MS-Off Ver
    MS Home and Office 2019
    Posts
    10

    Re: How do I copy data to end tab and have it appear sorted?


  7. #7
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: How do I copy data to end tab and have it appear sorted?

    You're welcome. Thanks for the feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sorted copy data in new worksheets
    By ccsmith in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-17-2014, 02:16 AM
  2. Replies: 3
    Last Post: 10-08-2013, 02:59 PM
  3. [SOLVED] How to Automatically Copy New Data into the next sheet and have it automatically sorted??
    By ReedDOT in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-24-2013, 10:50 AM
  4. [SOLVED] Sorted copy of a table
    By laszlo.kocsis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-10-2012, 04:02 AM
  5. [SOLVED] Copy Sorted Coloumn
    By Pete in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2006, 05:30 PM

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