Hi

I'm working with a massive excel workbook. In the workbook there is a column with a number of item codes (Column A), On my userfrom there is a textbox that finds the item code and populates a load of textboxes on the userfrom with all infromation form that row. It then allows the user to change any of the textboxes he wants and he presses a command button (Add Details), the new updated version then finds the next empty row and goes there successfully.

The problem with this is that there are now 2 rows with the same item code, I wonder is it possible that when i click the command button Add Details that it would delete the previous row where the item code was and leave the new updated version.

Thanks