Defining Segments of Text From General Workbook

Hey everyone,

So I am very new to macro's but I am trying to accomplish a relative simply task (in my mind) on my workbook. What I have is a drawing number for example B123A45B12B012, each segment of this number has a variable defined by my worksheet. So for another example I will break up that number into what I am pulling; B123-A-45-B-12-B-012. Again each segment of this already is defined in my workbook with dozens of different values depending on that number, I would like to be able to type my part number in and either A. have it highlight all my fields of data that apply, or B. re display all my needed data in a new table easy to read, to avoid having to search through this long document for my needed info. Any help is very much appreciated and thanks in advance for those who contribute.