Hoping someone can see the error of my ways in the below.
THis designed to do two things...
1. If the record already exists, I simply updates it (works fine)
2. If the record doesn't exist, write it the historical sheet. (Doesn't work. Gives the "Object variable or With block variable not...