Combine Several Worksheets within a Workbook

E

Erika

I have a workbook that has 700 worksheets in it, a client would like me to
combine all the worksheets so they are on one. Each worksheet has anywhere
from 6 rows to 125 rows of information.

Is there a quick way via a macro, function or other excel feature, that I
could do this?
 

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

combine worksheets 1
how can I combine multiple worksheets into a single workbook? 5
how do i combine excel worksheets 1
excel: combine several spreadsheets into one workbook 6
Merge data from different worksheets 3
Collate Worksheets into single workbook 3
combine rows with similar data, but different fields in excel 1
How do I combine data (not consolidate) from separate tabs to one? 2

Top