Create a single sheet from many sheets

[MS Office]

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

[Anne Troy]

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

"MS Office" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[Ron de Bruin]

Hi MS Office

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


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


"MS Office" <[email protected]> wrote in message news:[email protected]...
> 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
>