Here's my scenario: I have a worksheet with two columns, User ID and
Soc. Number, and I have another worksheet with just User ID's (however
not all of the User ID's are present from the first worksheet and some
are present multiple times). I need to replace the User ID's in this
second sheet with the corresponding Soc. Number from the first sheet.

I can't seem to figure out a way to do it programatically, and so far
have had to do it manually by copy/psating an flipping between the two
sheets. If anyone could shed some light on a solution it would be much
appreciated.

Thanks!
Dominic