Worksheet 1 = Output
Worksheet 2 = Lookup
I want to ensure that the names in worksheet 1 are the same as worksheet 2.
Is there any code to do this

"crazybass2" wrote:

I am not clear as to what you have/want....what I think you have is 2
workbooks, one with sheet names "Fred Bloggs" and "Richard Smith" and
another workbook with sheet names "Mr Fred Harry Bloggs" and "Mr Richard John
Smith" and you want the second workbooks sheet names to match the first. Is
this correct?

If this is the case, is it always the same pattern (ie. remove the prefix
and the middle name)?

Mike
"mhd143" wrote:

Not sure how to go about this, but what i'm trying to do is that from an
output worksheet i want to ensure the names column matches the lookup
worksheet names. I then want the names in the output worksheet replaced with
the entry from the lookup worksheet.

OUTPUT(before)
Mr Fred Harry Bloggs
Mr Richard John Smith

LOOKUP
Fred Bloggs
Richard Smith

OUTPUT(after)
Fred Bloggs
Richard Smith

Thanks