thanks.

both methods work although they don't account for blank cells as they
paste the data to the first blank cell in column A. But no worries,
i'll see what I can do to solve that. This has got me started and given
me something to help me understand this sort of looping with ranges and
using counters etc...

thanks again, luke


--
luke
------------------------------------------------------------------------
luke's Profile: http://www.excelforum.com/member.php...o&userid=21401
View this thread: http://www.excelforum.com/showthread...hreadid=375917