Results 1 to 3 of 3

Sorting and conditional selecting of data from sheet 1, inserted to sheet 2?

Threaded View

  1. #1
    Registered User
    Join Date
    04-13-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    2

    Sorting and conditional selecting of data from sheet 1, inserted to sheet 2?

    I have this sort of chart on sheet 1:

    Test 1 2008 Random text 1
    Test 2 2010 Random text 2
    Test 3 2007 Random text 3
    Test 4 2008 Random text 4
    Test 5 2008 Random text 5
    Test 6 2010 Random text 6


    I want sheet 2 to be able to look like this, updating as sheet 1 updates:

    2007
    Test 3 Random text 3
    2008
    Test 1 Random text 1
    Test 4 Random text 4
    Test 5 Random text 5
    2010
    Test 2 Random text 2
    Test 6 Random text 6

    i.e., auto-sort on the date, and then insert the selected data for that year before moving onto the next year.

    I have no clue.

    Thank you for any and all help!
    Attached Files Attached Files

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