Search Range for Specific Multiple Unique Values and Copy/Paste

Hi All,

I have range G2:G1302 of which each cell has a variety of lengthy descriptions in them. In most of these cells is one or more references to a WT number. This is shown at "WT-XXXXX" where "XXXXX" is the number. Sometimes it is a 5 digit number, sometimes a 6 digit number. The "WT" is always preceded by a ">" character, and the "XXXXXX" number is followed by a space or "<". So I need to use this criteria and extract every time an unique WT number is called out in the G cell and past that value in column H, I, J, etc. based on how many unique WT numbers are in that G cell. This is more than a simple "Find" macro due to possibly copying more than one value from the G cells, so I'm hoping to get an assist. Attached is an image of what I'm talking about. Notice the multiple "WT-XXXXXX" numbers. Thanks in advance!

Luke

That worked great! I found a few exceptions, but I should be able to work with your code to include those. Thanks so much!

Okay. So I've been messing with this for the past few hours and it turns out there are too many variables after the "XXXXXX" number. However, I have noticed that all these numbers are 6 digits long. So how can I modify the above code to copy/paste the number after identifying the unique WT value? Thanks again!

-Luke

If you upload a workbook with the data and result that you want, it will help.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

An example workbook should be attached. There are only a few rows, but it shows how I need to isolate/copy/paste each instance of the WT-XXXXX number that's in the description cells. Thanks again.

- Luke

Try

Please Login or Register  to view this content.