You can copy a worksheet only to workbooks that are open. So open the
workbook before you copy a worksheet to it.

"lm" wrote:

i only can copy and move to the home workbook or a new workbook, which i
don't want. is there way i can move a worksheet to a specific workbook?
please help.