View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
eric eric is offline
external usenet poster
 
Posts: 1
Default copy all worksheet data into a new worksheet

hi,everyone:
I have a excel file of 7 worksheets. I will need create a new
worksheet and copy each 7 worksheet data and paste into the new
worksheet. Is there a macro to do that?
thanks.
Eric