Hi,
I have a worksheet,
Now I have two sheet named Face and Metal.
What I want is a VBA code against the button "Delete" in the sheet "Metal" that, if in the sheet "Face" the value in the column AL is 0 then the entire row will be deleted in the "Metal" sheet.
The values in Column J in "Face" and Column F in the sheet "Metal" is unique.
I am uploading a dummy sheet for reference.
Thanks in advance.