Hello,

I have a large database of information found down column D that was extracted from a program I use at work. The program jumbled all of the important data into one cell. In these cells contains device names which they are linked to. Example:

D10: B40148.9 CV-19 AVB MAN PL RAM 00089
D11: B40147.10 CV-10 RUNNING PL RAM 00074
D12: B40148.5 FA-05 AVB MAN PL RAM 00085

The device names are CV-10, CV-19, and FA-05. These are only a few devices as there are about 30 total. So what I would like to do is go down the list of devices I have and enter a device (Ex. FA-05) and have excel automatically search all the cells down column D and the ones with the (FA-05) text in the cell copy the device name (FA-05) into the corresponding cell in column E.

Any help with this is greatly appreciated since I am new to this forum and to macros and VBA.

Thank you,

-AS