+ Reply to Thread
Results 1 to 1 of 1

Adjusted question - Copy data to 2nd sheet based on criteria and sort

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

    Adjusted question - Copy data to 2nd sheet based on criteria and sort

    Hello, my question "Copy data to 2nd sheet based on criteria PLUS sort & wrap in 2 column range" was viewed by 64 people, but no one has suggested a solution. I take this to mean that I was asking for the impossible, or at least not something that can be done with a formula. You're the experts. I'll take your word for it. SO, I'm modifying my question...removing the wrapping up to second column requirement, since I suspect that was the tricky part.

    Thank you to all who scratched their heads about my original question! Please, I still need help with the the more basic part. I'm attaching an amended file.

    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) 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. Replies: 0
    Last Post: 03-01-2015, 01:56 PM
  2. 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
  3. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  4. Replies: 4
    Last Post: 07-24-2012, 07:09 AM
  5. Copy data from a sheet to other based on a criteria
    By arun88aries in forum Excel General
    Replies: 5
    Last Post: 02-22-2011, 06:13 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