I have a user form that is populated from a workbook that lists informaion on
various projects. The user selects the project they wish to update via a
combo box. Once the user updates the project and presses save, two copies of
the project appear on the worksheet with the oldest copy on top. I
automatically sort the project to ensure both copies of the project are
showing together. What i want to do, via VBA code, is if, after sorting,
there are two rows of project information together (match found) then delete
the first instance of the project. For example, project 10 is titled Civil
Engineering. My user selects Civil Engineering, updates various start and
end date information, or generic project information and presses SAVE. Once
SAVE button is pressed, the worksheet is sorted and both copies of Civil
Engineering appear one above the other, with the newest second. I want, if
there are two copies of a project, the oldest (lowested numbered row) to
delete. Can Anyone Help