My loop is missing last iteration

Hello everyone

I got a master file containing numbers in column H.


See pictures
VLfTF4L.png


also I have got lots seperate files in a folder "C:\data\"
each of these files contains numbers in column H

File 1:
LSkuVP2.png

File2:
TuQ3ERP.png


Now I need to loop through all cells in column H in the master file, compare each cell in column H(master file) to the each of the each number in the column H in the seperate files.
If the number is the same copy the value in the seperate file from the column G same row; paste it in the column G in the master file in the same row as the first number but column G.

My problem is my loop is missing the last iteration I dont know why.

See my code below:

Please Login or Register  to view this content.

Could someone help me?

Thank you in advance

Originally Posted by JohnTopley

Your code wasn't looping through the files in the folder

Try

Please Login or Register  to view this content.

Somewhat confused by which column the numbers are in : your code suggests "I", your description "G" and an image "T"!!!

The comparison loop could be replace by MATCH function.

The loop is skipping some values strange?

Here is a link to my DATA folder
http://www.megafileupload.com/kmyK/DATA.zip

also for my xlsm file

http://www.megafileupload.com/kmyM/Loop.xlsm

Thank you in advance.

Cross-posted

http://www.mrexcel.com/forum/excel-q...sure-what.html

Just try to remove that line

Please Login or Register  to view this content.

@elmnas

Even though this is solved, please note your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).