sooty8
08-30-2008, 04:30 AM
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
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