Results 1 to 12 of 12

copy non contiguous columns to another sheet in differen order

Threaded View

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    copy non contiguous columns to another sheet in differen order

    Hello everyone
    I am searching for an easy way (using arrays if poosible) to copy non contiguous columns from Source sheet to Destination sheet
    In Source sheet that data has headers (I don't want to depend on the headers) the data starts at row 6
    and in the destination sheet, the data would start at different row which is 10 >> I need the copied columns in different columns ..

    for example:
    Range("A6:A22") in source sheet would be in Destination sheet range("F10:F26") and the same with other columns

    I imagine to have two arrays for column numbers and from these arrays it would be flexible to copy any column in the source sheet to any column in destination sheet

    SourceArray=array(1,2,3,4,5) 'The original column numbers in source sheet
    DestinationArray=Array(6,5,7,4,3) 'The new columns in destination

    Hope it is clear
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy contiguous columns and paste as non-contiguous
    By absconditus in forum Excel General
    Replies: 1
    Last Post: 12-29-2014, 03:17 AM
  2. copy and paste columns in a specific order on a different excel sheet.
    By milkfloat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2013, 01:36 PM
  3. [SOLVED] Need macro to copy columns to a new sheet in a different order
    By dip11 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-07-2012, 10:10 AM
  4. [SOLVED] Separating Data in a Single Cell into differen Columns
    By veejar in forum Excel General
    Replies: 4
    Last Post: 05-26-2012, 01:55 PM
  5. Copy and paste non-contiguous columns
    By spasmous in forum Excel General
    Replies: 4
    Last Post: 04-12-2006, 04:30 PM
  6. Create copy of sheet using VB with columns in different order
    By Bryan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-04-2005, 12:06 AM
  7. Replies: 3
    Last Post: 03-03-2005, 02:06 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