View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sherry Sherry is offline
external usenet poster
 
Posts: 116
Default Creating a new file for each excel worksheet

I have an excel file with many worksheets (tabs). I now need each sheet to
be its own file with its own name. Is there any way to just "right click" on
the worksheet and paste it into a new file? Or, do I have to do it the long
way, and open each sheet, and copy the cells before pasting into the new
file. I have a lot of them! Thanks !
--
sherry