Replace or delete row

[klatlap]

Hi

I have setup an inventory database that has a custom user form the contents of the user form are sent to sheet "Database" my question is when i update the information i am not sure how to update it, can i use a macro to replace the row with the new information or should i just delete the row and add a new row to the bottom.

I use a vlookup in column A to find the row with the info i need.

 

[texasalynn]

if you are going the way of a macro then which would be better? replace or delete

 

[klatlap]

Sorry i didn't get back to this been busy, i would rather replace the old info with new info