I need to write a macro, where the macro would match a date from a range in row and then take the values from a range in same sheet and paste values only it in that column.
I'd recommend uploading sample workbook as attachment. With your set up and expected output created manually to show end result that you are after. Without it, you'll likely not receive much help. And if you do receive help, it may not be what you have in mind.