When you copy something from one workbook to another, you must have bothworkbooks open. The following link provides information ontransferring data from one worksheet to another.http://support.microsoft.com/kb/247412/EN-US/