+ Reply to Thread
Results 1 to 2 of 2

Need Help Optimizing Copy Paste Rows from Sheet to Sheet

  1. #1
    Registered User
    Join Date
    12-23-2017
    Location
    Larkspur, Colorado USA
    MS-Off Ver
    Office 365
    Posts
    1

    Need Help Optimizing Copy Paste Rows from Sheet to Sheet

    Hi, I'm hoping someone can point me in the right direction. The code below works as expected, however it is very slow... It takes at least 5 minutes to complete and I would love to learn a better way to code this so that it runs much faster. Any ideas for me? Thanks!

    Please Login or Register  to view this content.

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,170

    Re: Need Help Optimizing Copy Paste Rows from Sheet to Sheet

    Hi baldbrian

    Welcome to the Forum...I am very certain that we can assist.Upload a sample file so that we have something to work with...

    To attach a file, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ 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. [SOLVED] Copy/Paste part of rows from sheet A to B if value does not exist in sheet B
    By gv29 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-30-2016, 02:33 AM
  2. Replies: 4
    Last Post: 09-08-2016, 11:13 AM
  3. VBA needed to copy only rows from sheet 3 meeting criterium YES and paste in sheet 4
    By Robert1311 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2014, 10:33 AM
  4. Copy diff cells of a sheet & paste in a NEW row below previously filld rows of other sheet
    By shubhashishdubey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2014, 12:36 AM
  5. Search row with criteria in all sheet, copy rows and paste in new created sheet
    By dekueb in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-24-2013, 01:42 PM
  6. Replies: 1
    Last Post: 01-07-2013, 12:23 AM
  7. Macro: Count rows in sheet A, copy count in sheet B, paste offset in sheet A
    By Agent:Orange in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-19-2011, 07:56 AM

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