My Life With IT

I seem to have lost touch with looping. The codes look fine to me. However, the final count is wrong. I can’t figure out why. Perhaps I have really lost passion for coding at this point in time. Maybe I’m just bored with the programming and yearning for changes in my life. Or perhaps I yearn to fulfill my childhood dreams.

Anyway, this set of codes is supposed to check for the category then the location and finally count if the document belongs to the set. Unfortunately, the count is off. With 2 or 3 loops, I can’t help but wonder if I had been programming the codes all wrong from the start. Or the conditions need another way to work around.

Arrays and variables have to be used. It’s going to be tough.

I kept having problems with a loop. It was certainly frustrating to get it to work the way I wanted it to. With the source data not being modified in any way, I had to somehow find the row that was to be read and imported.

Took me a few days to get it done because I was simply sick of it and got exasperated easily. I just had to add another loop to locate the data just above the identified source before the import. That was all it took and without all extra If-Else loops that failed to get anything.

I need a change of scope.