+ Reply to Thread
Results 1 to 8 of 8

Code to Copy Paste Every Next Row

  1. #1
    Registered User
    Join Date
    08-07-2022
    Location
    Canada
    MS-Off Ver
    2021
    Posts
    39

    Code to Copy Paste Every Next Row

    Hi,
    I want that values from this Range Q10:T10 should be copied. Then it should be pasted as simple numbers in this Range Q7:T7. Then again code should copy values of this Range Q7:U7. Then it should paste these values in this Range K10:O10 as simple numbers.
    Again, values from this Range Q11:T11 should be copied. Then it should be pasted as simple numbers in this Range Q7:T7. Then again code should copy values of this Range Q7:U7. Then it should paste these values in this Range K11:O11 as simple numbers. (And So on. it will be keep on doing this until values ends from Q10:T10 onward)

    Please see attached file for more Clarification

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Code to Copy Paste Every Next Row

    Base on your guide, at the end, the left table with be exact with right table? and Q7:T7 = Q34:T34?
    While not copy at once?
    Quang PT

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Code to Copy Paste Every Next Row

    Why loop through the ranges to apply a formula and then copy the data + solution across? Why not just copy the formula down in column U? You could then just Copy and Paste Special | Values over the formula.

    That would be a lot quicker than a loop and, at face value, achieve the same result.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,496

    Re: Code to Copy Paste Every Next Row

    Please Login or Register  to view this content.
    @TMS. Why do it easy if you can make it difficult!!!!!
    Experience trumps academics every day of the week and twice on Sunday.

  5. #5
    Registered User
    Join Date
    08-07-2022
    Location
    Canada
    MS-Off Ver
    2021
    Posts
    39

    Re: Code to Copy Paste Every Next Row

    Hi jolivanes,

    Thank you so much. It worked perfectly as i wanted

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Code to Copy Paste Every Next Row

    @jolivanes: you got me? Maybe the OP is not looking for the quick and/or easy solution.

    Edit: ok, apparently he is.

  7. #7
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,496

    Re: Code to Copy Paste Every Next Row

    Thank you for letting us know and Good Luck.

    Something like this is what TMS had in mind I think.
    Please Login or Register  to view this content.
    @TMS.
    You have me wondering. Are you early or late (timewise)?
    Not that it is any of my business but with the time difference it is either one or the other.
    If late, have a good rest soon and if early, have a good day.
    Last edited by jolivanes; 08-10-2022 at 01:19 AM.

  8. #8
    Registered User
    Join Date
    08-07-2022
    Location
    Canada
    MS-Off Ver
    2021
    Posts
    39

    Re: Code to Copy Paste Every Next Row

    Hi jolivanes,

    Thank you so much. It also Worked

+ 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. Need help to make code faster (The code copy/paste)
    By Beginner77 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 09-13-2023, 05:16 PM
  2. [SOLVED] Copy and paste code in one line of code
    By gipsyfkls14 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-08-2020, 07:50 AM
  3. VBA Code to copy/paste & cut/paste
    By panyagak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2017, 04:02 AM
  4. [SOLVED] Tweak Code for Copy and Paste Special vs Cut and Paste
    By Adam Schaefer in forum Excel General
    Replies: 1
    Last Post: 04-18-2016, 11:12 AM
  5. [SOLVED] Paste restriction code in vba not affecting GUI copy/paste only Ctrl+V
    By DT211569x in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2016, 01:28 PM
  6. Replies: 0
    Last Post: 10-29-2013, 09:38 AM
  7. Copy and paste code pasting won't paste just values
    By thehotbreadguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2013, 11:12 PM

Tags for this Thread

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