Run a loop in Master file and find match in files located in another folder

[epoiezam]

Hi Guys

Need some help here,

Looking to automate my daily task using VBA.

Got this master file with list of customer's id (column A - Alphanumeric). What I'm trying to do is to run a code from the master file which will :-

1) Loop Master file - column A starting from cell A3 and try to find a match from a bunch of Data files located in a different folder.
2) When there's a match, VBA will copy & paste the whole row from Data to the Master (paste in B3)
3) Loop will continue with next row A4, A5 and so on until cell value =equals blank

Thanks in advance, really hope there's something to make my work easier.

 

[pbornemeier]

Glad to help.

 

[epoiezam]

Hi pbornemeier,

Shared the said program with my colleague today.. Like me, he really loves it.
But he did raise a question, what if there's a possibility of dupes ID in a single files due to a human error or should there
be a future amendment to the source file data format - To allow duplicate ID)

So if it is not asking too much, could you also included - the possibility of a duplicate ID in a single file..

 

[pbornemeier]

I will work on that.

 

[epoiezam]

Thank you so much pbornemeier.. Really appreciate it..