So I have a matrix of data and one of the columns has a bunch of ID's. I'm trying to make a script that can load N workbooks and see if any of those ID's appear in the other workbooks, and build a new list of those ID's and which workbooks they appear in.
To do this I have a Dictionary where each element is a matrix of the data in the N workbooks.
So for instance I have
myreports(1) = 2010 data
myreports(2) = 2011 data ect
So what I'm doing is
Looping through the ID's
looping through the workbooks (using dictionary K's)
and running Application.Match(ID[x], workbook(k), 0, IDcolumn)
and if there is a match I take that ID and put it in a new dictionary I'm creating to store the data I need.
actual code
fundraisingdata (matrix of current data)
funreports (dictionary holding matricies of previous years data)
size (calculates how big the array needs to be to store all the potential matchs)
So this code is rather expectantly taking forever to run. Can anyone think of a more efficient way to do this? I know I can do it manually comparing the data in Excel using VLookUp so I assume there has to be a better way?
Bookmarks