Thanks to some previous communications on mrexcel, I obtained some help generating the subroutine below. The only problem is that it quits working under each of the following conditions:
If “ABC” is not contained within Cell C7 it stops at this line of code –
.Copy wbR.Sheets(1).Range("B10")...