Move Rows from one sheet to another sheet without having duplicate entries

Hi Guys,

I need to move the rows from one sheet to another sheet upon clicking the ‘Submit’ button.

I will manually update my efforts in ‘Sheet 1’ and when I click ‘Submit’, it should “copy” the rows to the next sheet (Sheet 2). However, it should not duplicate the entries irrespective of clicking Submit multiple times. Obviously, while clicking ‘Submit’ it should check the entry for that particular employee name and date in the ‘Sheet 2’ and remove that completely and update the new entries and this should avoid duplicates for that date. Every time when I add new entries for a different name and for dirrerent employee, it should keep appending the Sheet 2.

In addition, it should avoid copying the blank rows from Sheet 1 (S. No column will not be blank usually) to Sheet 2.

All this should happen upon clicking the Submit button.

Please help me with the macro code.

Please let me know if you need more details. I have attached my sample sheet for reference.


Thanks,
Vijay N