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