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

H Sixthsense,

Thank you for your quick reply. This works perfectly for copying the 1st row. However, if I have more than one entry, it does not move to Sheet 2.

I am sorry if I missed to mention this, a person can have several entries on a same date. So there can be same task repeated (with the same time as well) while filling the form. So, let us consider taking the complete rows without checking the duplicates while submitting.

However, on Sheet 2, every time it copies the rows from Sheet 1, it should remove the rows for that employee name on that particular date and do a fresh copy.

Thanks in advance for your time and support, greatly appreciated.

Please refer my updated file.

Vijay N

H Sixthsense,

Thank you. I updated different tasks (Task 1, Task2, etc.) for the Employee John. When I Submit the form, it copies as expected.

However, when I changed all the tasks as ‘Task 1’, the new changes was not moved to the ‘Sheet 2’.

We are trying to match the Employee name and date while moving to Sheet 2. If it exists in Sheet 2, we need to remove the entire rows and do a fresh copy.

Appreciate your time and efforts.

Vijay N

Thank you friend.

I am really sorry for my ignorance. Your initial code doesn't copy more than one row to Sheet 2. After changing Array(1, 2) to Array(1, 2, 3), it copies all the rows to Sheet 2 which is fine. However, when I make edits to the tasks by changing all the tasks as "Task 1" (same name) and when I submit again, the entries in Sheet 2 remains unchanged. I am assuming that while copying, it does not remove the existing entries in Sheet 2.

Try to work on the file which I sent and you will know what I exactly mean.

I am really sorry as I am just a beginner with excel macros.


Thanks,
Vijay N

Also, everytime I click submit, it keeps adding an entry horizontally... like A to G, H to N and so on...

@vij8y
In your attachment you have identical entries in the first sheet and nothing in the 2nd sheet.
If that is reality, all you have to do is copy the last row over to the 2nd sheet although all the rows are the same and we have to assume that the last row is the latest entry.
Attach a representative workbook with different scenarios.

Hi jolivanes ,

Thank you. I have attached my sample file for your reference.

Sixthsense’s code works perfect. However, I believe it requires a little tweak to meet my requirement.

Please refer the attached file (Move Rows_Test). I have updated the tasks for a particular date and when I click Submit, it copies all the rows to the next sheet which is good.

However, I changed the ‘task name’ as same in my latest entry (Move Rows_Test2) for the same date. My expectation is, the latest list of entries should replace all the previous entries. This doesn’t happen. The look-up value should be ONLY ‘date’ AND ‘employee name’; tasks may be repeated.

I have attached associated workbooks with this post.

Thank you for looking into this.

Regards,
Vijay N