variables not updating in embedded loop

After I import a data table that has start, arrival, and departure times assigned to vehicles, I want to find those times in a time table I created that has 1440 columns for every minute of the day. So my outer loop is looping through the data table line by line to assign the time values. The inner loop is supposed to find the cells with the matching values in my time table. Its accurate for the first loop, but the subsequent loops are not finding the right cells even though I know the outer loop is updating the values from the data table. To be more clear, the "1" variables are updating correctly, but the "2" variables are not. What am I missing? Thanks! -Luke

Please Login or Register  to view this content.

A sample is uploaded.
stime2 columns should be: pe, qa, vv, wz, xi, aef
atime2 columns should be: pj, tr, wr, xb, ady, afm
dtime2 columns should be: qa, vv, wz, xi, aef, afu
After the first loop, its seems like its hit or miss if the values will be updated or not. Could it be a processing error? 1440 columns is too much to loop through? Thanks again. -Luke

It seems to work better only when I manually find the values I need in the time table using ctrl-f. Then the embedded loop will seem to find the corresponding value in the time table. But this is not a realistic solution and I have no idea why this makes it work better.

Proton - Thanks for the revised code. However, I'm still having an issue with a few of the "2" variables not updating to the corresponding time values. Its just like Excel refuses to acknowledge the value in the time table cells until I do a ctrl-f to expose it. This wasnt supposed to be this hard...

I couldnt solve why my inner loop wasnt finding the values in my time table, so I resorted to recording a macro to use "find" and it works like a charm. So, not exactly solved, but solved. -Luke

Please Login or Register  to view this content.