Record a macro and do the following...
Copy the sheet (Hold down the Ctrl key and drag the sheet to one side or the
other)
Sort the sheet however makes you the happiest
Click on Data - Subtotal
Choose how to subtotal based on the form
Click OK
Optionally you can also format the data
Format
AutoFormat
Select your favorite...

Stop recording

HTH

"kdreyer" wrote:

I am trying to create a macro that will create a new work sheet called
Summary, take all of the items on the active worksheet, Move them to the
summary Sort them so that all of the items that have the same description are
together then combine each matching description into one record that will
total the qty for that description. That way we can summarize all of the
items.