View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MikeD1224 MikeD1224 is offline
external usenet poster
 
Posts: 34
Default Create and name multiple sheets

I currently have a worksheet named 1-1-2007. I need to copy this sheet 60
times and rename each. The names for each sheet are contained on Sheet1
(named "Schedule") and are in column C.

Can I use a macro or an array formula to do this? Any help would be great.

Thanks,

Mike