Let's say you have 2 worksheets, in the first worksheet you have lots of different data. In D column, you have a number (in bold). First part of the number are 2 or 3 letters and then a couple of digits after it (number of digits can vary), for example Let's say you have 2 worksheets, in the first w