View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Multiple Sheets to one sheet

See
http://www.rondebruin.nl/copy2.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Michael" wrote in message ...
Hello,
I am looking for a mcro that will copy the contents of multiple sheets to
one sheet. For example I have a workbook that has 10 sheets sheet1, sheet2
etc. I would like to copy all of the sheets into one sheet say sheet 11.

I looked for similar posts but did not find any.

Thanks in advance