Macro/VBA to Search, Copy, Paste - without creating duplicates

Hello Excel Forum!

I've been working on an excel file for a few days now with no luck. In short, I have a row of data that will update based on a date input that the user specifies. I'm looking for a way to copy and paste that data into a separate sheet each time it updates without creating any duplicates.

Here are the details of the sheet...

Under the "Date" tab, the user will input their date of interest. The data in the "Losses" tab will automatically update to reflect the data from the day of interest (in the actual sheet it does, this sheet is not linked). I'd like to somehow copy and paste the data under the "Losses" tab to the "Time" tab in chronological order. This data could then be used to create graphs to see trends over time. However it's important that the data will not be pasted into the "Time" tab if it's already present in the sheet - users may go back and view data from an earlier date, but I wouldn't want that to create more points for graphs.

Thanks in advance!

AutomaticLosses.xlsx

Bump to top!