Help cleaning up data

I am currently writing a macro to analyze a lot of data that I have collected along with ym graduate student monitoring cell motility and cooperativity. The macro I included runs well and does everything I desire except in the beginning of the macro I have need to identify each cell by its trajectory or cell number. My process of doing this which is visible in column D works as I like but it fills some empty rows (that are present because of the tab delimited data format) with trajectories. Then for later analysis I copy these columns and sort them a different way but now these numbers I spoke of above are displayed at the very bottom of my sorted data and are causing errors in my next calculations. If anyone can think of a way to exclude these numbers or have my macro delete them I would greatly appreciate the help.

I've uploaded a sample workbook with the macro already run. It's a relativley small sample but if you scroll to the bottom of columns G:R you can see the undesired data that is creating various errors. Also my macro is included below and please as always feel free to ask questions.

Please Login or Register  to view this content.