Hi all,

First off let me explain that I am an utter novice at Excel - I can just about make the squares pretty colors, do big letters and small letters, etc etc. So forgive the lack of tech speak.

Basically I'm trying to make a macro that will automatically search a worksheet for multiple words/phrases, select the cell next to it, copy it, and paste it to a different worksheet in the cell next to the same word. Confusing? Here's an example:

Worksheet A contains the following:

Chris | 2000
Bill | 3500
Tom | 6000

With the | representing a division between 2 different cells.

Worksheet B contains the following:

Tom |
Bill |
Chris |

Obviously with the second cell blank, and the names in a different order (so it can't just be copy/pasted as is).

What I'd like is to be able to set up a macro that, in this example, will automatically fill out the contents of the 2nd cell from worksheet A into worksheet B, based on what is in the first column. It will be on a significantly larger scale than this example but the same principle applies (I think).

I'd greatly appreciate any help, thanks for reading this gibberish. If anyone needs further clarity I'll do my best to explain.