vba to check if matches column A & B& J before pasting

[orange12345]

Hi there,

Hope everyone is staying healthy and having a great weekend.
I have a specific range (A to J) in file 1 I need to paste to a centralized date file 2, I was able to get macro to do that.
However, I also want to enable macro before pasting, check if the centralized file 2 column A, B and J already has the data matching column A,B J in the file 1, if it exists, then a message pops up asking the user do they want to replace the existing or just not paste the data. If users click yes, it should delete all records in the centralized file 2 that matching A&B&J and paste the new data, if no, it should just cancel the operation

Hope I have explained this as clear as possible. Let me know and thanks for your help in advance.


Thanks!

 

[orange12345]

Thanks all for your help in advance.

 

[orange12345]

Thanks all in advance~