Sorting macro

[joshag]

This is to find duplicate catalog items on a sheet. New numbering convention has changed the cat#'s from 1111223333 to something like 01111-22-3333. The only thing that stays constant is the catalog names.

The sheets Row 1 is used by buttons to initiate "Find Duplicates" and "Finish". Row 2 is the column headers from the catalog sheet pasted into it. There are approximately 500 rows but this is subject to change week by week so 600 is a safe bet. There are two sheets "Main1" and "Main Sort" because after the duplicates are found they have to be taken to a second sheet where I have a series of formulas that combine some columns and divide others (PITA but works for now)

The macros I have been using are mostly just clumsy "cut and paste" from the recorder. The first button/macro just sorts column C, starting at row 3, alphabetically and highlights the duplicate values of column C. The second button/macro copies the results from "Main1 Sort" (Row7 and beyond) back to "Main1" and then again sorts alphabetically. This process is done twice in the workbook with sheets 1 and 2 sorting the catalog and 3 and 4 sorting the inventory totals. Both use the same cat#'s and descriptions.

I am attaching the cut and paste macros in hopes that someone can lean them out. The workbook struggles just to open with my nightmare macros.

Thank you,