Moving data from A to B - How to optimize for large data sets

[GodOfGrain]

Hello everyone

My question concerns the probably most fundamental thing on Excel: Moving data from one place to another.

I have several tables with about 20,000 rows of data. I am using a Database-ID (“DB_ID”) which is common in all tables. I then loop through table A, read out the DB_ID, search it in table B to find the corresponding source row and then transfer the data I need.

For this purpose I have first used the “Application.Match” command.

Later I switched to defining a search range and using the “.find” command, which allowed me to deal with cases the DB_ID is not found. Following is an example of the latter approach:

Please Login or Register  to view this content.

Now, while this does work as intended, it is getting quite slow. Some operations take several minutes by now, which really adds up.

Do you please have any suggestions how I can improve my code.

Kind regards

GodOfGrain

[Olly]

Use Power Query instead.