+ Reply to Thread
Results 1 to 8 of 8

Copy and paste to every nth column

  1. 12-18-2014, 05:39 PM #1
    ant1905
    ant1905 is offline
    Registered User
    Join Date
    03-28-2012
    Location
    Istanbul
    MS-Off Ver
    Excel 2010
    Posts
    43

    Copy and paste to every nth column

    Hello friends,

    I could not figure out the tweak with my limited understanding of VBA. The purpose is to copy a range of cells, like A1:A10 and
    paste it to every 5th column consecutively (paste to 6th,11th,16th,21st nd so on ). The limit to paste loop is 50 so it will copy a1:a10
    and paste it 50 times after every 4 columns.

    I have a code that does that only once but I was not able to tweak it to fit my needs. Thanks alot in advance for any help or direction.


    Please Login or Register  to view this content.
    Last edited by ant1905; 12-18-2014 at 05:52 PM.
    Reply With QuoteRegister To Reply
  2. 12-18-2014, 06:08 PM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,937

    Re: Copy and paste to every nth column

    Try this

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 12-18-2014, 06:14 PM #3
    ExcelClout
    ExcelClout is offline
    Registered User
    Join Date
    11-12-2014
    Location
    New York
    MS-Off Ver
    2010
    Posts
    28

    Re: Copy and paste to every nth column

    Try this out.

    Please Login or Register  to view this content.
    Cheers!
    Reply With QuoteRegister To Reply
  4. 12-18-2014, 06:16 PM #4
    ExcelClout
    ExcelClout is offline
    Registered User
    Join Date
    11-12-2014
    Location
    New York
    MS-Off Ver
    2010
    Posts
    28

    Re: Copy and paste to every nth column

    alansidman, you beat me to it!
    Reply With QuoteRegister To Reply
  5. 12-18-2014, 06:26 PM #5
    ant1905
    ant1905 is offline
    Registered User
    Join Date
    03-28-2012
    Location
    Istanbul
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: Copy and paste to every nth column

    Thanks alot to alansidman and ExcelClout. Most appreciated , both solutions work flawlessly.
    Reply With QuoteRegister To Reply
  6. 12-18-2014, 07:51 PM #6
    ant1905
    ant1905 is offline
    Registered User
    Join Date
    03-28-2012
    Location
    Istanbul
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: Copy and paste to every nth column

    Maybe I was too enthusiastic to mark as solved the last time For future users who might be looking at this thread I had to come back and correct two points and ask for one more tweak.

    alansidman's solution work perfectly except in my case I needed to copy paste a range of cells. I think Alan's code copies the whole column not a range ...like a1:a10
    Excelclouts code copies the range but does the first pasting 1 column short... then starts pasting with correct periods.
    Reply With QuoteRegister To Reply
  7. 12-18-2014, 08:33 PM #7
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,937

    Re: Copy and paste to every nth column

    If you only want A1:A10 copied then change to this

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 12-18-2014, 08:39 PM #8
    ant1905
    ant1905 is offline
    Registered User
    Join Date
    03-28-2012
    Location
    Istanbul
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: Copy and paste to every nth column

    Perfect! Thanks so much Alan...
    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. Assistance with VBA CODE to find column on worksheet 1,copy contents of that column paste
    By Bevg in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-01-2014, 04:30 PM
  2. How do I make the copy/paste of one column contingent on the copy/paste of another?
    By Kwasimitsu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-23-2014, 01:51 PM
  3. Foruma to query 1 column then copy the next column across and paste to a new column
    By spartagnus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-22-2013, 01:08 AM
  4. Vba - find next empty column, insert column, copy paste values & copy paste formulas
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2012, 12:43 PM
  5. Save column J only using copy/paste & temporary copy
    By mikeburg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2006, 12:37 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1