+ Reply to Thread
Results 1 to 1 of 1

Sort two columns (names) with keeping data intregity and order within the columns

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Sort two columns (names) with keeping data intregity and order within the columns


    This is my first post to this website! I have been lurking on here for sometime now...

    I have been dabbling with macros for a bit, but this is my first major one I have tried to construct/meld together from what I have seen online. I am beyond stuck and close to giving up.

    I am trying to meld two data sets together. Each have names that may or may not be in the other data set, but when they are in both columns I need the names to line up. Thus, it is possible for a name in "Name 1" to never match up with a name in "Name 2", when this occurs I would like spaces to fill up the gaps. Also, I have two separate entries for each name, with an in and a corresponding out time, it is silly, but thats the out put I was given, and these need to line up in order to calculate duration. So it is possible in one data set to have 2500 John Does and in another data set have 6400 John Does (the exact same person), but also 0 Mark F and 10 Mark F's. No names can be deleted, just shift arounded with its corresponding data.

    Please see attached example.


    My current macro which doesnt do anything :

    Please Login or Register  to view this content.
    Last edited by JBeaucaire; 02-15-2015 at 12:18 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

+ 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: 6
    Last Post: 07-18-2014, 12:19 PM
  2. [SOLVED] Sort the order of columns based on values of header?
    By Granite-Granny in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-14-2014, 08:05 PM
  3. Keeping columns in order
    By mega_nerd in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-16-2013, 06:44 PM
  4. Match two columns of names while keeping data in rows aligned
    By SpaceWheels in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-27-2013, 02:22 PM
  5. Sort order (ranking) for miltiple columns of data
    By plannerg in forum Excel General
    Replies: 2
    Last Post: 10-19-2010, 07:02 AM


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