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.