Help with Loops

[Impartial Derivative]

I am writing a macro that has to sort and display selected data depending on certain criteria. The data is tab delimited and sorted by trajectory number which is equivalent to the cell number. However, each cell also reports x and y coordinates via frame number as well. I'm trying to sort the x and y coordinates by frame number and then test them in relation to a given cell to see if they are close enough to be considered neighbors. I have an array formula that will report all x coordinates of frame 1 and I can easily modify this to report the coordinates for any frame but I'd like to create a loop that will do it for all frames no matter the number. I know this is not the most efficient way to accomplish what I want but at this point it is the only option I'd come across so any help would be greatly appreciated.

My code to display the coordinates for frame one is as follows:

Please Login or Register  to view this content.

Once again I'd just like to loop this so it will do it for all frames present in the data set. I've uploaded a sample of what the raw data looks like before any macros have been run.

[Leith Ross]

Hello Impartial Derivative,

It would help to see what the desired output is as well.

[Impartial Derivative]

Hello Impartial Derivative,

It would help to see what the desired output is as well.

Leith,

Here is a very brief example of an output file. I'm not concerned with the formatting so don't make that a priority. I am mostly concernced with the efficiency of the macro as it incorporates arrays and loops.