I open the worksheet then click on Edit/Move or Copy/ Check the copy to box.
I then indicate where I want the worksheet. Then click OK.

My workbook has about 12 sheets to it. I can copy 7 of the 12. The others
I can't copy. Is there something I might have turned on that won't let me
copy the 5 worksheets?? 4 of the 5 that won't copy are very similar.

Thanks for the reply.

"Gord Dibben" wrote:

How do you produce the new worksheet from the master worksheet?

Knowing the method of producing the sheet would greatly assist in
trouble-shooting.


Gord Dibben Excel MVP

On Fri, 11 Mar 2005 10:43:03 -0800, KCoyne
wrote:

I have afiarly large worksheet that I use to help determine production data
and to keep track of production data. My people have had some problem with
the workbook lately and I added some formulas to assist them. One feature I
use daily is to produce a new worksheet from a master worksheet. this
usually works, but for some reason it has failed to work lately. Any help
would be appreciated.

I am using Excel 2000