if you want to use built in find/activate features, you need to examine
*active* cell [retrieve its range] after doing find, and not to use flat
for/next
Not sure how this would be done or what you mean here. I did try to
just take out this find step altogether and noticed it actually ran a
little faster without so unless this new way would be a step up over
that I'll just leave it out for now.

any speed improvement so far?
A small improvement has been seen. It still takes upwards of 20
minutes for jus a couple thousand records. I considered sorting the
data to shorten the loops but doing so would eliminate the option of
allowing multiple sheets ( one per day ) as the list would always be
starting back at "A".

sometimes it is all due to the data structure/design matter. if badly
organized data, it is hard to have lightspeed program.
Would sorting it make that big of a difference? One possible solution
I see for the multiple sheets would be to carry over the ID and search
once per sheet to find the one being worked and move forward from
there.

keep us informed.
On a different note I was considering the possibility of building
arrays and working with the data there. The idea would be to grab all
the rows of a single ID and loop the arrays against each other with
the statements you saw originally. Then once the output was put on
column "K" I would a check to see if there was a value there and skip
that row if so. Thoughts on this, worth a try or way overcomplicating
it?