Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 791
Default Multiple Sheets to one sheet

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 791
Default Multiple Sheets to one sheet

Ron thanks for the quick feedback.

I will try this out.

All the best.

Michael
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
summary sheet across multiple sheets Drew[_2_] Excel Discussion (Misc queries) 3 April 1st 08 04:48 PM
multiple sheets vs. 1 sheet Wally Excel Worksheet Functions 1 July 1st 05 02:49 AM
splitting 1 sheet to multiple sheets dfeld71 Excel Discussion (Misc queries) 5 June 9th 05 07:51 PM
Splitting a sheet between multiple new sheets Jon C Excel Programming 2 May 16th 05 02:52 PM
Merging multiple sheets into one sheet J Excel Programming 5 November 29th 04 12:24 AM


All times are GMT +1. The time now is 08:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"