Pulling different results based on table sorting

I have a list of tasks in a master table that I split out by function (AP, AR, purchasing, etc.). I have columns set up for each function, which I then tickmark with a "1" indicating that the task in that row corresponds to that function

I have a script that takes a specific function (say, purchasing) and places it in a separate worksheet. It copies specific information from about each task to the co-responding worksheet.

Everything except for the "% Complete" works fine, every time. The "% Complete", however, gives me different numbers depending on how I sort the master table (ex, ascending vs descending, based on date, ID #, etc.). In other words, task "A" might show as 100% complete if the master table is sorted ascending by date, but 0% complete if sorted descending by date--even though everything else about the task (the name, dates, description, etc.) all get copied correctly. I'm at a loss as to why that is.

Here's a snippit of the code:

Please Login or Register  to view this content.

Like I said, I'm at a loss as to what is happening. It seems like it should pull correctly since it's the same code that is used to pull everything else.

I can manually observe that nothing changes to the task when changing the sorting. In other words, task "A" on the master list will show 0% complete, irregardless of how the table is sorted, however it may get copied as 100% or 0%, depending on how the table is sorted.