View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jill Jill is offline
external usenet poster
 
Posts: 52
Default assemble worksheets into one workbook

Is there an easy macro I can use to take all the workbooks in a folder and
save them as a single workbook with multiple tabs?

Each workbook has only one tab, and I would like to save them in one
workbook with multiple tabs.

I know this can be done manually, but I have to do it every day, so a macro
would be much easier.

Thanks!