I checked your previous file learned the concept of Dictionary from your
examples Tried the same achieved the results before 6 seconds. Ya from now
I can say Dictionary is much better than the manual vlookup.
Sub t()
'Doing Variable declaration
Dim Folderpath As String: Folderpath =
"
What format are the original (5) files in?Are they text, csv, or excel files?
What is the relationship between the 90,000 records and the other 5 files?That
is, do the records show up once in the list of 90,000 and show up multiple
times in the 5 files?What are the "key" field? (those in common
