Deleting Duplicate Sections Of Data

In my spreadsheet (27,000 + rows), there are sections (multiple rows) that are duplicates of other sections. A section is a header row followed by other rows of data.

The number of rows in each in section can vary from 5-20 – therefore, you cannot use the number of rows as a criteria.

However, each section has a header row that contains a four digit number. The following is an example of two such sections:

Basic -- Zero Line ==> Zero Line ID=7076 (submitted by Calvin Campbell)

Star Thru

Pass Thru

Trade By

Star Thru

one half Square Thru

[Code] ..........

As you will notice the header row contains an ID number. Every header contains “ID=” followed by the four digit ID number.

I need a macro that will identify the duplicate IDs and their sections and delete the duplicate rows of data.

I mention the following – which may or may not be useful.
- Not only are the header rows duplicates but the content of the entire section is duplicate
- There are no blank rows in the spreadsheet
- Entire rows may be deleted (not just specific cells)
- The data will be in Column A
- There’s only one duplicate of any given ID

There are a total of 2716 sections. It has been determined that 201 of them are duplicates. I can provide the 201 duplicate ID’s if needed.