Search results

no, that won't work either. I think i'm just gonna give up. I made sure that the master list was sorted and i checked out all the addnew/update code, but it still has these anomalous results. oh well...

I did a little more debugging...i can definately see that the addnew function is sometimes skipping to the middle of the table and inserting records there. How is that even possible?

tried accepted.moveLast...still has the same problem...and like you said, it shouldn't be necessary. The problem seems so random...sometimes, the tables will be in order, but other times, they won't. I ran it like 20 times in a row, and about 1 out of every 4 tries was wrong.

yes. I have a function which counts how many people have records in the two tables (one person can have multiple records). The way my function works, it must be in the same order that the master list was. I guess i'll just have to keep troubleshooting...

But the master list is already in alphabetical order. That's the problem. Shouldn't the add method add the records from the alphabetical master list in order in the two tables?

yes... I want the appending order to be alphabetical for the two new tables, just like the original master table

I have a sub that is supposed to split a table (which is imported from excel) into two tables based on a value in the column "Award Categroy" (sic). This main table "list" is in alphabetical order, and the two new tables should be, too. However, sometimes, this sub does not add the entries to...