Hello,

I have a workbook full of data (Incident data reported to my helpdesk) that
is sorted into columns as follows:
Incident ID
Modified By
Contact Name
Last Modified
Current Status
Title

Duplicate data is produced in the workbook if the incident data had a change
of status in its lifecycle (Eg. from Open to Resolved to Closed). I want to
know how I can automatically delete rows of data if one particular row has
the word, 'Closed' against it?
Eg.
If Row 1 had an Incident number of 1 and Row 2 had an incident number of 1
and the corresponding Status had a value of Open in Row 1 and a value of
Closed in Row 2, how can i automcatically delete both rows?

Please contact me if more information is required.

Thanks,

Marc