I have a macro that copies and pastes where I want it, and adds another date. The problem is that it adds the date, it should, for example, add another month to 2021-11-30 as 2021-12-31 and add 2021-12-30, so it does not draw me data by the index match function.
VBA Code:
With wbMe.Worksheets("input_6")
.Range("Y26:AJ26").Copy Destination:=.Range("X26")
.Range("AJ26").Value = DateAdd("m", 1, .Range("AI26").Value)
End With