Merging worksheets within the same workbook

[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?

 

[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.

 

[Pecoflyer]

Have a look at 'this site' (http://www.rondebruin.nl/tips.htm)

 

[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?

 

[Ron de Bruin]

Hi Lesa

See
http://www.rondebruin.nl/copy2.htm