You're gonna want to kill me... <_< Ok, so...this is working great, and I can definitely make what I want to do happen with it, but I think I found a better way to do it from an ease-of-use standpoint.

So...what I would want the whole thing to do, if I could figure out how (and I totally understand if you don't want to mess with this) is this, in order...


1) Copy the present value of cells X2:X16 to cells CL2:CL16
2) Search cells J32:J38 for "String 1" and, if found, replace it with "String 2" and go to step 5, otherwise go to step 3
3) Search cells J32:J38 for "String 2" and, if found, replace it with "String 3" and go to step 5, otherwise go to step 4
4) Search cells B24:B38 for "String 4" and, if found, increase the number in corresponding cell in column D by 1 to a maximum of 5, and add the overflow to cell CK1 (making CK1=1 if it would otherwise make the D cell a 6, =2 if CK1 already =1, etc.)
5) If step 4 sets the corresponding D cell to 2, add "String 2" to the topmost empty cell in range J32:J38
6) Copy the new present value of cells X2:X16 to cells CM2:CM16


If I can make it do that, I can make it so the entire operation will be handled in one click for the end user...but I have no idea how to do it...