VBA to copy data to new column if date doesn't allready exist.

Hello guys, first post here !

First off I know that there are a lot of similar use cases for my problem but my knowledge is just not good enough to adapt it to my situation .. so here goes ..

I have a workbook in which the user fills in values in Sheet1 (C5:C20) and at the top of Sheet1 (C2) the user fills in the date.

Now I would like a vba code to copy the values that have been entered into Sheet1 (C5:C20) to another sheet (Geschiedenis) like this:

_____A_____B_____C____
1 | date1 | date2 | date3
2 | valu1 | valu1 | valu1
3 | valu2 | valu2 | valu2
4 | valu3 | valu3 | valu3
etc...



and here's the catch.. it has to check for that date (primary key) if there are existing values or not and if there are it should overwrite them.

I hope I'm making sense and any of you can find the time to help a noob out ..
My boss would be super-happy :p

Hi Steve,
Welcome on the Earth and Excel Forum.
How is weather on the Moon?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Please find the attached sheet. I have inserted another button the sheet1 and assigned the code "CheckAndFillData" to this.
In this code you can include your code for saving and printing the sheets. Just add your code before the End Sub line of CheckAndFillData code and don't forget to declare variables in the code as well.

Thanks a lot, works like a charm !!!

Great. Glad to know that.

If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.