When the value QUAR is found I want to number the values like I have below. They will only appear in the configuartion below. But can be anywhere in My Range



I'm trying to turn this :

QUAR QUAR QUAR QUAR QUAR QUAR QUAR QUAR
QUAR QUAR QUAR QUAR QUAR QUAR QUAR QUAR
QUAR QUAR QUAR QUAR QUAR QUAR QUAR QUAR
QUAR QUAR QUAR QUAR QUAR QUAR QUAR QUAR
QUAR QUAR QUAR QUAR QUAR QUAR QUAR QUAR
QUAR QUAR QUAR QUAR QUAR QUAR QUAR QUAR

In to this:

QR101 QR101 QR101 QR101 QR101 QR101 QR101 QR101
QR102 QR102 QR102 QR102 QR102 QR102 QR102 QR102
QR103 QR103 QR103 QR103 QR103 QR103 QR103 QR103
QR104 QR104 QR104 QR104 QR104 QR104 QR104 QR104
QR105 QR105 QR105 QR105 QR105 QR105 QR105 QR105
QR106 QR106 QR106 QR106 QR106 QR106 QR106 QR106