I have a userfom populated with names from sheet 1, what I want to happen is when a name is selected on the userform and the delete button is clicked that it will search sheets 2,3,4,5,6 for a match to the name from the userform and delete the data from each sheet with a match.
The data that needs to be deleted is name from column A and all data in that row up to column W.
I have attached a workbook with the userform and the other sheets.
Thanks for any assistance.