+ Reply to Thread
Results 1 to 2 of 2

Optimize/Speed up macro in large data file when copying data and pasting betw. wbooks

  1. #1
    Registered User
    Join Date
    04-02-2011
    Location
    Espoo
    MS-Off Ver
    Excel 2007
    Posts
    16

    Optimize/Speed up macro in large data file when copying data and pasting betw. wbooks

    Hi,

    I have very large data file (wb1) around 50000 rows of data and 65 columns and I am trying to make a macro based on user input which is used to find correct rows from the data file and then copy and paste data of these rows to an other workbook.

    User has 3 workbooks open; one contains the data (wb1), one contains the macro and user input form (wb2) and the third is a target for copying data from the data workbook (wb3).

    So user inputs digit in wb2 and starts the macro. Then macro looks for this digit in certain column in wb1 and when finds the digit, copies values from several columns of the same row to first blank row and certain columns in wb2. The amount of possible rows is not known and can be just a few or thousands.

    My macro works fine when testing with small amounts of data but otherwise it is kind of slow and jams the computer. I'm just a beginner and I would appreciate if someone professional could just check the macro through and maybe suggest some corrections.

    Here is the macro:

    Please Login or Register  to view this content.
    I guess it is quite simple but is it best possible...?

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Optimize/Speed up macro in large data file when copying data and pasting betw. wb

    hi, sepi, it would be helpful to see workbooks: wb1,wb2,wb3

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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