I have a simple userform where data is inputted and the that data is put on work sheet. Coloum I is Date, J is Tech Name, K is Equipment Type, and L is Equipment ID.

I would like a text box where a Tech types in Equipment ID and press a button and search's for that data and takes you to that cell on the sheet. If the Equipment ID is not on the sheet it give a message. It would be really nice if possible that pressing the button it search's the sheet and it deletes that row.

The way the form works is the Tech checks out equipment by entering the Date (I), Tech Name (J), Equipment Type (K), and the Equipment ID (L) in the form and he clicks the "Enter Button" and it will look in column I (date) for the first empty cell (which I want to always be the last row).

I would like when the Tech checks equipment IN he would search for the Equipment ID in its own test box and it find the row it is in and delete that row and move the row below it up so there will not be any empty rows as I want the column (I) that has the Date in it always be in ascending order with the oldest date at the bottom with no empty rows in between.

My form works great for adding data to the worksheet. I just cant get it to search the worksheet and it go to that cell or better yet go the row it is in and delete the whole row.
I have attached jpeg of the form.
form.jpg