Search Based On Cell Contents - Delete Row on another Sheet

Hi All,

I am working on a project which is a form that is being filled out. Once its completed and saved on another tab (which I already have code for), I want the Macro to search on another sheet, for the contents of a cell on the form which changes after the form is completed each time. Once found on the other sheet, I want to delete the entire row. The search results will all be in column A on the second sheet.

I have search everywhere and am not finding specifically what I need. I have tried recording a macro but the Macro looks for the same record over and over.

I have attached a mock up of the spreadsheet.

Any help you can provide would be greatly appreciated!

Les (Excel 2013)

Thanks for the quick reply.

On the sheet to be searched and deleted the record numbers will always be unique. The same number would also be on the archive data tab but I dont want that sheet searched. I would want to limit the search and delete to the all data worksheet.

Strange. The macro runs, no errors but doesn't appear to do anything. Did it work for you?

I'm an idiot. I edited it with my actual sheet names but missed updating the cell reference to D5 on my actual project.

It worked! Thanks so much for your help!

Les

haha will do