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?

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.

"Lesa" wrote:

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?

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


--
Pecoflyer

Cheers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=33952

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?

"RCY2" wrote:

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.

"Lesa" wrote:

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?

Hi Lesa

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Lesa" wrote in message ...
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?

"RCY2" wrote:

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.

"Lesa" wrote:

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?