Copying Worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a 2mb workbook. I have 10 sheets in the workbook set up with formulas
to calculate labor cost (hours x pay). I have made 20 copies of this sheet
and need to continue to add more. The program will not copy the sheet
anymore times. How do I continue to copy and add sheets in the same workbook?
 
Anita

You say you have 10 sheets and you made 20 copies of "this sheet".

Which "sheet" did you copy?

Or did you mean 20 copies of each of 10 sheets for a total of 200 sheets?

"Will not copy" means what? Error message?


Gord Dibben MS Excel MVP
 
Sorry I was unclear. I was trying to make 20 plus copies of one sheet in the
workbook. Sheet labeled 'labor 1'. Was able to copy this sheet 20 times.
When I try to 'make a copy' again I don't get any error message, just will
not copy sheet.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
dynamic data copying between worksheets 0
changing worksheet reference name when copying down cells 5
Auto Update worksheet references as new worksheets are added 1
Automatic Cell Copy to other worksheets 1
Relative worksheet reference for multiple worksheets in a workbook 5
Macro to copy value in field and insert it into filter 2
Re: Can't insert a new worksheet 3

Back
Top