Looping a Macro to bring in various cells according to a variable.

[mminte]

Here is my code:

Please Login or Register  to view this content.

Basically this grabs a term from H1 and searches the Datasheet to find rows that match. It is then supposed to paste in the Cells 2-4 in the first three columns in another spreadsheet. Then the variables change and it is supposed to paste cells 9-11 in the next 3 columns of the spreadsheet.


As it stands it does paste everything needed but first it pastes only the first three columns then it repeats and pastes all the information needed below that (filling cols 1-6). This gives me double information. I only want it to do the last iteration.

Please see the attached xlsm file to understand what I am talking about.

[mehmetcik]

Q1: Should you be modifying this statement based on i?

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

Q2: How much data do you have?
Your code is really slow.
There are much faster solutions available to you.