Hello all,

I am really new to programming in VBA and Excel, but have a lot of experience in C++ and Matlab. I have thousands (anywhere from 20,000 to 500,000) of data points to match using latitude and longitude (two columns against two columns), and then must export those matching points and their other associated values into two new columns in order to run analysis on the acceleration values. Each "row" of data contains 8 columns, so my smallest file size is 2 x 8 x 20,000 filled boxes (320,000 boxes). I have written a For/Next code that works on small files (around 200 rows each), but am just trying to find the easiest method to actually match the data without crashing this cheaper computer.