View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lynn Lynn is offline
external usenet poster
 
Posts: 131
Default create 50 copies of a worksheet in the same file

I want to copy a certain worksheet within xcell, 50 more times. I don't want
to do it one at a time. Is there a command to copy it multiple times?

After setting up the multiple copies, I want to name them from a reference
list inside the same workbook, so that the tab name appears from a name
entered in a cell location, from a directory of names. Is this possible?

I would like the worksheet tabs to flow from left to right in alphabetical
order automatically, as entered, or be able to sort the tabs in alphabetical
order.