Merging worksheets within the same workbook

L

Lesa

I have many worksheets within one workbook and I want to make a new worksheet
that contains ALL of the data from all of the worksheets into one worksheet
so that I can sort that one huge worksheet. How can I accomplish this?
 
R

RCY2

You can hi-light then "right click" and "Cut" the selection out.

Then move to the new combined sheet and "paste."

This will leave all formulas in the sheet the same, the only problem you may
face is if you have list boxes that are referenced somewhere you will have to
do those again.

I have done this a few times myself, and it works well for me just needs
some tweaking to get all correct.
 
L

Lesa

That would work well with a small amount of data, but I have 112 worksheets
in the workbook with a small amount of data on each sheet. Is there a way to
do a merge or do a copy and paste of all sheets into one so I don't have to
manually go to each sheet?
 

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

Identical Cells in Multiple Worksheets in one Workbook. 4
finding duplicate addresses across 2 worksheets in the same workbo 2
autofilters on worksheets within workbook 4
How to paste across 20 worksheets within one workbook 3
Compare data (2 columns) from 2 worksheets within a workbook 2
How do I find like data in multiple worksheets? 1
merging data/worksheets 1
Auto populate one worksheet from other worksheets 4

Top