View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] dswiders@gmail.com is offline
external usenet poster
 
Posts: 19
Default Macro to paste worksheets in another workbook

I need to be able to have worksheets from multiple workbooks copied
and then pasted to the end of another workbook. I have the code set
so that the user can type in the file they would like to open for
everything to be pasted to but I dont know how to have worksheets
from
separate workbooks pasted in. Any suggestions?