David,

Since both your data source (copy) ranges and destination (paste
ranges are not systematic ie do not conform to a discernible pattern
you cannot apply looping to any effect. I would suggest that yo
restructure your data such that the source data maps into th
destination ranges in a certain kind of fashion (but this may no
always be possible)

--
david
-----------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...fo&userid=2064
View this thread: http://www.excelforum.com/showthread.php?threadid=49597