+ Reply to Thread
Results 1 to 11 of 11

Copy multiple Columns & paste in interval of 2 Columns

  1. 01-29-2015, 12:29 AM #1
    Faridwahidi
    Faridwahidi is offline
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Copy multiple Columns & paste in interval of 2 Columns

    Hi,

    can anyone help me?

    I want the destination column to be pasted in interval of 2 but it does not work 

    Please Login or Register  to view this content.
    Last edited by Faridwahidi; 01-29-2015 at 12:32 AM.
    Reply With QuoteRegister To Reply
  2. 01-29-2015, 01:10 AM #2
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,567

    Re: Copy multiple Columns & paste in interval of 2 Columns

    Could you explain in words what you would like to accomplish.
    Code that does not work for you does not work for us neither.
    Reply With QuoteRegister To Reply
  3. 01-29-2015, 01:42 AM #3
    Faridwahidi
    Faridwahidi is offline
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Copy multiple Columns & paste in interval of 2 Columns

    Hi Jolivanes,

    I want the destination columns to be pasted in interval of 2. can you help me?
    the above code pasted without interval
    Reply With QuoteRegister To Reply
  4. 01-29-2015, 02:20 AM #4
    Faridwahidi
    Faridwahidi is offline
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Copy multiple Columns & paste in interval of 2 Columns

    Hi Jolivanes,


    I have copied multiple columns and want it to be pasted in interval of 2

    This code pasted without interval. data pasted in column E, F,G,H,I,J,K, L

    Please Login or Register  to view this content.
    I want it to be pasted interval of 2 columns e.g. E,G,I,K,M,P,R,T . Can you help me?
    Last edited by Faridwahidi; 01-29-2015 at 02:28 AM.
    Reply With QuoteRegister To Reply
  5. 01-29-2015, 02:31 AM #5
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Copy multiple Columns & paste in interval of 2 Columns

    maybe
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 01-29-2015, 02:37 AM #6
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,567

    Re: Copy multiple Columns & paste in interval of 2 Columns

    Maybe somebody else knows what you want to do but I don't.
    For me to even start trying to give you an answer, read Post #2 again.
    Reply With QuoteRegister To Reply
  7. 01-29-2015, 02:38 AM #7
    Faridwahidi
    Faridwahidi is offline
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Copy multiple Columns & paste in interval of 2 Columns

    Hi nilem,

    You missed understood.

    Offset(1, 2) will only go from column E to F.
    But the output pasted without interval.


    The output shout be in columns E,G,I,K,M,P,R,T. in Interval of 2 columns
    rather than E, F,G,H,I,J,K, L without interval.
    Reply With QuoteRegister To Reply
  8. 01-29-2015, 02:46 AM #8
    Faridwahidi
    Faridwahidi is offline
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Copy multiple Columns & paste in interval of 2 Columns

    Hi nilem / Jolivanes,

    Please refer to my attachment.
    The output should pasted in interval of 2. (Columns highlighted in yellow)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 01-29-2015, 02:55 AM #9
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Copy multiple Columns & paste in interval of 2 Columns

    something like this
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 01-29-2015, 03:30 AM #10
    apo
    apo is offline
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: Copy multiple Columns & paste in interval of 2 Columns

    Hi..

    Something like this too maybe..

    Change "Sheet1" to the sheet you want your values to go to..

    Please Login or Register  to view this content.
    The output shout be in columns E,G,I,K,M,P,R,T. in Interval of 2 columns
    Main reason i didn't apply it to your sheet is because you have some discrepancies in your requirements and the Workbook you posted....

    Example: An interval of 2 after "M" would be "O" ??
    Last edited by apo; 01-29-2015 at 03:36 AM.
    Reply With QuoteRegister To Reply
  11. 01-29-2015, 09:01 AM #11
    Faridwahidi
    Faridwahidi is offline
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Copy multiple Columns & paste in interval of 2 Columns

    Hi Nilem

    Thanks a lot. the code working fine.


    @ apo
    I learnt new method from you. yes after M should be O in interval of 2.


    So, I can conclude that, we would be able to copy multiple columns in interval at one time but cannot paste it in interval at one time?
    Last edited by Faridwahidi; 01-29-2015 at 09:06 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy data from multiple columns and paste into single columns
    By daniel_t in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2015, 11:20 AM
  2. Macro to Copy from 2 Columns, Paste Value in the next 2 Columns, Then clear 1st Columns
    By MHALTTUNEN in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2014, 03:34 PM
  3. [SOLVED] Copy/Paste multiple columns as values based on another columns criteria
    By Dgp2012 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-28-2013, 06:50 AM
  4. [SOLVED] Faster way to copy and paste multiple columns in Sheet1 to corresponding columns in Sheet2
    By babbeleme1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-19-2013, 12:55 AM
  5. copy and paste of columns with interval
    By pani_hcu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2009, 10:11 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1