Hi,

I'm a total novice when it comes to writing macros and am desperately trying to figure out a way to write code to sort out a messy database.

Essentially, I need to search for specific text in one column and if present, copy the value from an adjacent cell (same row) and paste this value into another cell (same row, different column). This needs to be done for three specific text searches.

For example...

Column J needs to be searched for "E2", "LH" and "FSH".
If "E2" is present in a cell, the value in column M needs to be copied and pasted into the corresponding cell in column N on that row.
If "LH" is present in a cell, the value in column M needs to be copied and pasted into the corresponding cell in column O on that row.
If "FSH" is present in a cell, the value in column M needs to be copied and pasted into the corresponding cell in column P on that row.

Any help or advice you could give me would be greatly appreciated!
Thanks.