How do I consolidate many sheets in same file to 1?

G

Guest

I have a workbook that contains 465 sheets. Each sheet has about 50 items. I
would like to append all to 1 worksheet to export.
 

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

Need macro to consolidate all sheets in workbook 1
Consolidate work sheets 1
consolidate workbooks to worksheets in one workbook? 1
Copy cells from 4 w'sheets in multiple w'books to 1 w'sheet in 1 w'book 0
Renaming a worksheet in excel 3
Best way to pull data from several different sheets into a summary sheet 2
Need to merge worksheets - Excel 2003 0
consolidate over 50 sheets by Macro 7

Top