Ok. This is an exercise for my understanding of VBA. I am a little iffy on the syntax to paste a value in the next cell when a criteria is met?
BTW, I know I could do this via a VLOOOKUP in VBA, but in this instance I don't want to, this purely to learn the syntax for a situation like this
I am using Find in my code to get the value BTW.
Please Login or Register to view this content.