How To Delete row if a specific values exists (VBA)

[toradoya]

Good Day,


i will be brief, to not wasting your time.


How To Delete row if a specific values exists by Using VBA Code?


Reason: i have invoice sheet, and Sales sheet , i need a Button for the invoice sheet to delete some sales records if
a specific value exists in the sales sheet, the row in sales sheet will be deleted without wasting my time using the manual way


what the code will do !!:


• The code will First check 3 columns in the invoice sheet the bar-code, Date ,and Quantity,then find the match in sales sheet,
if the three values are matched with one of the sales sheet records , then that record will be deleted.


I attached a sample file for you : here

 

[toradoya]

there is a mistake in the sample file, the quantities in sheet 1 supposed to be 1 so the records will be matched with sales records, please adjust the quantities, and dates so they will be matched with sales sheet, i need to make this work

thanks