copying sheets

[chingchow]

I have two seperate worksheets.
One has only one sheet and the other five.
I would like to copy this one sheet to the worksheet that has five. I have done this once by right clicking on the sheet to be copied. It gave me a choice on the destination folder where i wanted that sheet to be copied to.
Now when i try to do this again, the destination worksheet holding 5 sheets is just not there anymore. It gives me the choice to copy to new folder only.
Thanks for your help and time.
M

 

[royUK]

Your destination workbook must be open. Check if you have closed it.
This message was edited by royUK on 2002-08-21 08:10