For a list of entries, overwrite in another tab if entry exists, copy/paste at end if not

Hi, all,
I've been searching around for a post on how to do this, but I'm awful at VBA and a lot of what I see is Greek to me. What the other posters are asking for, however, isn't exactly what I want to do and I don't know how to modify their code to make it work. Any help would be greatly appreciated.
What I need to do:
I have two tabs (I actually have three copy/pastes to do, but I want to at least try my hand with the others after I get some guidance here): MTD Data and Historical Financial Data. Column D lists our customer order numbers, or COEs, which are unique values. When the macro runs, it should check each COE in MTD Data to see if it appears in Historical Financial Data. If it does, it needs to copy from A:AE (very important that it not copy the whole row) and paste as values over the info for that COE in Historical Financial Data. If the COE does not exist, it needs to copy from A:AE and paste as values at the end of Historical Financial Data.
For example, if MTD Data has
COE Revenue
1 $100
3 $300

and Historical Financial Data has
COE Revenue
1 $50
2 $200

I need Historical Financial Data to be updated to show
COE Revenue
1 $100
2 $200
3 $300

Thanks in advance for any help. I may not be able to get back to you this afternoon, but I will try to this evening or tomorrow.

Try this. I was a little confused as to what happened to the 50 on your historical data, but I assumed you just forgot to include it on your "after the macro is run" example in your post.

Please Login or Register  to view this content.

The $50 was supposed to be overwritten with the new data for that COE, which it appears your code does. Thanks! I'm going to try to take care of the other two tonight or tomorrow. I appreciate the help!

I tried basically replicating your code, creating ws3 and ws4 and updating the ranges for my data on the next one, but I ran into a problem:
The next two copies come from the same tab. From the Gantt Chart tab, I need it to start at row 21 and match column A (the COEs again) to column A (starting in row 2) of the Historical Gantt tab. If the COE exists, I need it to overwrite from column A:AW; if not, I need it to paste that range as values at the end of the list. Then, A1 of the MTD Data tab has a date manually entered into it. I need AH4:BI4 on the Gantt Chart tab to copy and paste as values into the appropriate month (overwriting if necessary) of the Historical Bay tab from columns B:AC. The months in A on the Historical Bay tab are not text, but the last day of their respective months.
Thank you very much for your help!
(P.S. I tried uploading a dummy workbook, but the company I work for blocks it.) Please let me know if you need more explanation and thanks again.

I can try to do that later tonight. Thanks!

Here it is. Thanks for your help. It is very much appreciated. Please pardon the crude formulas and lack of formatting.

Bump. Thanks in advance to anyone who helps!

Bump. Thanks!