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:
I guess it is quite simple but is it best possible...?
Bookmarks