+ Reply to Thread
Results 1 to 2 of 2

Rearrange columns

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    Chennai,India
    MS-Off Ver
    Excel 2010
    Posts
    32

    Rearrange columns

    Hi ,
    I need a macro that can rearrange the columns based on the criteria that i give.
    Input:
    India, Pak, Srilanka, Aus, Germany, Spain

    Req output:
    India, Aus, Germany, Spain, Pak, Srilanka

    Note: All the countries are column headers.

    I need to specify certain countries and give their target columns.
    Like: Pak-5; Germany-3.
    All the other columns that are not mentioned has to remain undisturbed.

    Please help.
    Karthik

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Rearrange columns

    Hello Karthik can you upload a sample book
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

+ 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. Rearrange columns
    By Drigomaniac in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-16-2013, 01:02 PM
  2. Rearrange columns - loop perhaps?
    By tone640 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-20-2011, 09:18 AM
  3. Rearrange columns because of different dates.
    By Sveinpein in forum Excel General
    Replies: 1
    Last Post: 04-01-2009, 09:46 AM
  4. Rearrange columns using VBA
    By ktpack in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-07-2006, 03:57 PM
  5. Rearrange two columns of data
    By RexAtHighSpeed in forum Excel General
    Replies: 1
    Last Post: 12-20-2005, 04:30 PM

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