Ecxel Macro to summary and eliminate duplicates

[Guest]

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.

 

[Guest]

Hi,
Have you tried using a Pivot Table?
- select the Data with the Header field names
- menu Data > Pivot Table. The wizard dialog pops up.
- step 1 of 3: choose "MS Excel List or Database" and "Pivot Table". Click
Next.
- step 2 of 3: the selection (source data with header) address should
already be in there. Click next
- step 3 of 3: choose "New worksheet" and click "Layout". in the Layout
dialog, put the item number field in the Row Section and the field you need
to count or sum in the Data section. Click ok, then Finish.
Pivot Tables can be a bit intimidating at first, but experience a bit when
them, you can save a lot of time when you are used to them.

Regards,
Sebastien

 

[Guest]

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