+ Reply to Thread
Results 1 to 18 of 18

Converting 1 set of columns to 2 sets or more: Example Attached

Hybrid View

  1. #1
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Converting 1 set of columns to 2 sets or more: Example Attached

    About the format transferring, that can only be done through VBA.

    About the sorting, check this sample instead.

    Note that I make it so that when you change the number, the table will pull enough data so that the number of rows on each table is about the same as much as possible.
    Attached Files Attached Files
    Last edited by Lemice; 05-05-2013 at 01:56 AM. Reason: changing attachment
    (copy pasta from Ford)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools

    Regards,
    Lem

  2. #2
    Registered User
    Join Date
    05-04-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Converting 1 set of columns to 2 sets or more: Example Attached

    Thank you so much , but it doesn't seem to work. When you choose two columns it fails to sort in order and only gets worse as there are more columns...with regards to the formatting, I can solve that issue through conditional formatting.

    Please help me get the sorting correct!

  3. #3
    Registered User
    Join Date
    05-04-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Converting 1 set of columns to 2 sets or more: Example Attached

    Duplicate Post...Sorry!

+ Reply to Thread

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