software

I need to combine multiple sheets into one sheet so I can sort them all at
one time. I have a workbook I received from another person. Instead of just
having one worksheet, it has many worksheets, each a continuation of the one
before it. If it were only a few sheets I could just copy each sheet and
paste it onto the bottom of the first sheet. Is there a way of combining all
of these sheets?

See sample code on Ron de Bruin's site:

www.rondebruin.nl/

quot;Tomquot; wrote:

gt; I need to combine multiple sheets into one sheet so I can sort them all at
gt; one time. I have a workbook I received from another person. Instead of just
gt; having one worksheet, it has many worksheets, each a continuation of the one
gt; before it. If it were only a few sheets I could just copy each sheet and
gt; paste it onto the bottom of the first sheet. Is there a way of combining all
gt; of these sheets?