You have to be a little more especific.., maybe you could start using
some simple code like:
Sheet1.Activate
Range("B8:B12").Select
Selection.Copy
Sheet2.Activate
Range("D5").Select
ActiveSheet.Paste
Regards.
--
dbarelli
------------------------------------------------------------------------
dbarelli's Profile:
http://www.excelforum.com/member.php...o&userid=31275
View this thread:
http://www.excelforum.com/showthread...hreadid=510143