Macro to copy/paste values to new row OR overwrite existing row

Just signed up for this and having trouble finding a solution to the challenge I have at hand. I'm hoping someone can help, and I apologize if there's already been a solution posted, but I wasn't able to find it, so here goes!

I have a weekly report that will be used to collect data for an asset, and I have built a simple macro to copy & paste the values of that data to a new row on a separate sheet. The purpose is to keep a log of weekly stats so we can identify trends. The macro is working as intended, but I want to improve it to be able to account for a certain element of human error.

It is reasonable to assume that the people filling out the weekly report will at one point or another (or maybe more often than that) click the "Finalize Report" button which cues the macro to publish the data to a new row, then shortly thereafter realize that they need to correct some data and "re-finalize", thus re-publishing the data to a new row. This would result in multiple rows of data for the same date. The sheet where this is happening is password protected by design so that it can't be altered. I would like to redesign the macro to paste the data to a new row ONLY if the value in column A (the date of the report) is unique, and if the value in column A already exists in the list of data, then overwrite that row with the new data.

This seems like something that's possible, but I'm fairly new to macros, so I could use some help!

Here's the macro code as-is, which simply copies and pastes the values to a new row:

Please Login or Register  to view this content.

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

@will.good

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread