+ Reply to Thread
Results 1 to 1 of 1

Copy data to 2nd sheet based on criteria PLUS sort & wrap in 2 column range

  1. #1
    Registered User
    Join Date
    03-01-2015
    Location
    TEXAS
    MS-Off Ver
    2007
    Posts
    2

    Copy data to 2nd sheet based on criteria PLUS sort & wrap in 2 column range

    Hello Excel wizards!

    Thank you in advance for your help! I have created an example file that explains what I need to do. I need to do this using formulas not VBA.

    TASK: Automate the copying of names (col C) from Tab 1 (RAW DATA) to a specific, 2 column range on Tab 2 (GRID), based on value of Col B on TAB 1, such that,

    1) Names are placed in the right position on the "grid" on Tab 2
    2) Are sorted in alphabetical order
    3) Wrap to 2nd column within the quadrant if necessary
    4) Automatically update/shift position when data in the RAW DATA tab is modified

    RESTRICTIONS:
    RAW DATA file cannot be re-sorted

    THANK YOU!!!!
    Attached Files Attached Files

+ 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. Copy and Paste Rows based on Criteria onto another sheet and sort based on oldest item
    By Kushal8684 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2013, 05:37 AM
  2. Replies: 4
    Last Post: 07-24-2012, 07:09 AM
  3. [SOLVED] Copy Range of Cells to Another Sheet Based on Criteria
    By hedefinesme in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-15-2012, 02:04 AM
  4. Copy data to a sheet based on criteria in a range
    By cschaaf in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2009, 11:36 PM
  5. Copy Rows In New Sheet Based On Date Range Criteria
    By ahmedwaseem2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2006, 05:45 AM

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