View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rgxl rgxl is offline
external usenet poster
 
Posts: 1
Default Is there a way to create individual files from a multi sheet excel

I am new to Excel 2007 and I have a couple of questions. Often I need to
send users an excel file that contains multiple sheets of information. These
multiple sheets come from indivisdual excel documents that I copy into one
document. Is there a way to quickly create one large excel document from
multiple excel documents and have each individual file be a separate sheet?
Also if the reverse is possible, that would be great. Essentially saving
individual sheets as separate either excel or tab deliminated text files
would be extremely helpful.