Try using the Advanced Filter, Unique Items, then Copy and paste. Post
back if you need a macro to do this, or if you need more assitance.

Charles Chickering

StacyL wrote:
How can I remove repeated data in a filtered Excel database? Example: In a
spreadsheet I have Goals, Objectives and Staff Action. Each goal, objective,
and staff action was entered into it's own row. I can filter for Goal #1,
but some of the objectives repeat and the spreadsheet is 50 pages long. I
want to stop information from repeating. How can I do this without going
through the spreadsheet and pressing delete?