+ Reply to Thread
Results 1 to 9 of 9

Loop Thru Rows - Copy / Paste Other Sheet

  1. #1
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    Loop Thru Rows - Copy / Paste Other Sheet

    .
    Ok ... my grey matter is having another meltdown here. I've spent too many hours on this already.

    Please help me with the CopyPaste macro so it will loop thru all rows in Col A searching for the requested term (a number), then copy/paste the specified cells from the found
    rows to the other sheet.

    Thank you.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Loop Thru Rows - Copy / Paste Other Sheet

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    Re: Loop Thru Rows - Copy / Paste Other Sheet

    .
    AlphaFrog

    Thank you for the assistance.

    I know you won't believe me but I was going to try your macro the very next thing ....

    ( ya .. right )


    Thank you. I DO appreciate the help.

  4. #4
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Loop Thru Rows - Copy / Paste Other Sheet

    You omitted your Do Loop for the FindNext.
    After 'FirstAddress' line
    Please Login or Register  to view this content.
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
    Just when I think I am smart, I learn something new!

  5. #5
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Loop Thru Rows - Copy / Paste Other Sheet

    Quote Originally Posted by Logit View Post
    .
    AlphaFrog

    Thank you for the assistance.

    I know you won't believe me but I was going to try your macro the very next thing ....

    ( ya .. right )


    Thank you. I DO appreciate the help.
    You're welcome.

    Minor bug fix. Change this line...

    Please Login or Register  to view this content.

  6. #6
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Loop Thru Rows - Copy / Paste Other Sheet

    Is it what you need ?
    Please Login or Register  to view this content.
    Last edited by PCI; 07-24-2018 at 09:26 PM. Reason: Typo
    - Battle without fear gives no glory - Just try

  7. #7
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Loop Thru Rows - Copy / Paste Other Sheet

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 07-24-2018 at 09:29 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  8. #8
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,157

    Re: Loop Thru Rows - Copy / Paste Other Sheet

    It's probably some expert symposium ?
    So, maybe also something with arrays to the collection ?
    Please Login or Register  to view this content.

  9. #9
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    Re: Loop Thru Rows - Copy / Paste Other Sheet

    .
    This is why I L O V E this Forum. So many good folks assisting !

    Thank you all !

+ 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. Replies: 3
    Last Post: 11-06-2014, 01:23 AM
  2. [SOLVED] How to write a code within a loop to copy and paste rows on to another Sheet
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-24-2014, 08:40 PM
  3. Help on how to Loop Copy Paste to End of the Table VBA/Macro that do two rows only
    By jomapac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2013, 12:18 PM
  4. [SOLVED] Loop copy and paste in new sheet
    By tonnerre2000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2012, 12:22 AM
  5. Copy and Paste Rows For certain condition then loop
    By steve70070 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-14-2011, 06:05 PM
  6. Compare rows in column A and copy/paste if they are the same using a for next loop
    By Andrew C in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-07-2009, 01:26 PM
  7. Loop to copy rows and paste into worksheet
    By damien_carr1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2009, 06:10 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