Hi,
Sorry in advance as I am pretty terrible with Excel, but I hope you may be able to understand what I am asking!

I have 2 worksheets containing similar data but in different formats. On worksheet 1 I have pasted data from a print preview. Worksheet 2 is taken from an export file. However the export file drops out some of the information that I am able to see when I print preview the data. On ws1 I have my client codes and names (e.g. "90125 Mr Brown") in one column but in ws2 I have only the code 90125 . I would like to reference ws2 to ws1 to pick up the client name and drop it into a new column on ws2.

however the problem is that the data from ws1 is not in columns but is all over the worksheet. So I would like to know how to write a command that would let me fill a new column B2 in ws2 with "Mr.Brown" when B1 is 90125 by searching all fields in ws1 to find the "90125 MrBrown" field.

I'm sorry if this does not make much sense but as I say I am really not too familiar with the excel jargon. Thank you so much if you can help me!
jodero