Create a single sheet from many sheets

  • Thread starter Thread starter MS Office
  • Start date Start date
M

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel2007 | I want to create a pivotTable from a different data, and different sheets 0
Arrays containing variable sheets 2
Copy Data from One sheet to Different Sheets 1
More Rows/One Sheet vs More Sheets/Less Rows for best performance? 1
Excel, assign cells in multiple worksheets from one sheet 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Imbedded Data Input sheet 3
Custom Reporting Across Sheets 1

Back
Top