Combining worksheets

S

Steven Hunns

I have a large number of worksheets, all with the exact same format. I would
like to be able to have them all in one one worksheet, without having to
spend a large amount of time using the copy and paste functions. Therefore,
is there anyway of combining a number of worksheets within a workbook into
one worksheet, so that the data from one worksheet appears directly beneath
the next one?
 

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

How do I combining several worksheets onto one 3
Excel Synchronising Excel worksheets 0
Combine multiple worksheets in one Workbook into one big worksheet 6
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Naming ranges on multiple worksheets 3
Combine Data from several worksheets 1
Need to make page numbers sequential across worksheets 2
merging worksheets 1

Top