Create a single sheet from many sheets

's Computer Specifications

Hi,

I have a workbook with 20 sheets. All these sheets have the same coloumns.
To make a pivot table, I want to merge all these sheets into a single
sheet.Is there a quick way?

Thanks in advance
Mukesh

's Computer Specifications

Try this: http://vbaexpress.com/kb/getarticle.php?kb_id=151
************
Anne Troy
www.OfficeArticles.com

"MS Office" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> I have a workbook with 20 sheets. All these sheets have the same coloumns.
> To make a pivot table, I want to merge all these sheets into a single
> sheet.Is there a quick way?
>
> Thanks in advance
> Mukesh
>

's Computer Specifications

Hi MS Office

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

"MS Office" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Hi,
>
> I have a workbook with 20 sheets. All these sheets have the same coloumns. To make a pivot table, I want to merge all these sheets
> into a single sheet.Is there a quick way?
>
> Thanks in advance
> Mukesh
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create new sheets based off Data sheet, and template sheet	Midget	Microsoft Excel Programming	2	1st May 2007 09:55 PM
copy several sheets from a workbook to a single sheet in a new wor	=?Utf-8?B?c3Jpa2FudGg=?=	Microsoft Excel Programming	2	23rd Feb 2007 01:33 PM
Create a single sheet from many sheets	MS Office	Microsoft Excel Worksheet Functions	1	7th Sep 2005 08:07 AM
Combining Multiple Sheets into a single sheet	Steve Welman	Microsoft Excel Discussion	1	16th Jul 2003 12:46 PM
Combining Multiple Sheets into a Single Sheet	Steve Welman	Microsoft Excel Misc	0	16th Jul 2003 12:11 PM