Macro to copy/paste IF

[chisox721]

Hi guys, question pertaining to copying and pasting a row of numbers based on a condition.

Column A has a group of dates, with row 2 containing today's date and all below are dates ranging from today through 9/31. Basically what I need to do is have a macro paste the values to the right of today's date to the corresponding date below. Hopefully this makes sense and I have attached a sample sheet.

[gmr4evr1]

See attached, change the date in cell A2 and see if this is what you wanted

macro-to-copy-paste-if-sample2 Ver2.xlsx

[chisox721]

See attached, change the date in cell A2 and see if this is what you wanted

Attachment 401022

That's a start, now I just need to come up with the macro that will paste the values for the date so they are archived.

[gmr4evr1]

Meaning you need the values to remain in the cells even if you change the date in A2?

[chisox721]

Meaning you need the values to remain in the cells even if you change the date in A2?

Yes, basically the work you have done so far gets me to being able to copy/paste values for each given day.

What I would like a macro to do would be to paste the values each day for the current date.

I'm assuming the macro can be constructed by using some combination of IF A4:A143=A2, paste values of cells B2:AE2 into whichever date falls in A4:A143.

I'm somewhat familiar with coding but not exactly sure how to translate that.