View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eva Eva is offline
external usenet poster
 
Posts: 197
Default Copy sheets into one book

Hi
I have number of workbooks in C:\My Documents and I would like to copy
sheet1 from all of them and paste it into new book. Is there a macro to do it?

--
Greatly appreciated
Eva