Hi All

Scratching my head for a couple of hours with this.

On Sheet1 - Range B2:B400 are Surnames - Range C2:C400 are Titles
eg. Bloggs J.

On Sheet2 - Range A9:A409 I have J. Bloggs in the same cell

At the moment I am entering the data twice is it possible to just enter the data on Sheet 1 in the format shown above and the data would transfer automatically to Sheet2 in the format required.

Many Thanks

Sooty8