Copy and Paste value to another Sheets

Hellooo


I have a code that copy value from my "Data" sheet and paste to another specific sheets. My problem is this:

1. The date to be paste is not the date in specified cell at "Data" sheet, instead the date of the last row which are not empty; and
2. i want the Date column in target sheets to be the primary key to avoid duplicates entry.


Heres the code:

Please Login or Register  to view this content.

I attached the sample file for reference..