Hi somethinglikeant,

Your code worked like a dream, its probably saved me 4 hours of data
entry, thanks so much, its realy appreciated. I now have to copy
this data in each of the 976 rows, and paste it to a column in another
spread sheet, I hope I can do this using "transpose" do you know how I
can not include any blank cells when I copy?

Thanks again for you help

best

Lorraine


--
lorraine knight
------------------------------------------------------------------------
lorraine knight's Profile: http://www.excelforum.com/member.php...o&userid=35294
View this thread: http://www.excelforum.com/showthread...hreadid=550786