Copy value of merged cell to another cell.

Hello,

I created a automatic schedule (year, months, weekends and holidays) and I want to copy a value that is in merged cell (ex. G20) to another cell that must obtain that value via Excel Formula, our another way. For example, like in the picture, when I enter a value in cell G20 (A), I want it to automatically update the cell G13 (with A) and so on.

Any help will be very appreciated.

Schedule.JPG

Upgrade

Schedule-2.JPG

I think I may been not very clear. Like I said, this schedule is automatic, so it must do everything automatically. For more clarity, if I join the code below, it "works" but it gives me in the cell the error =imtrange(Cells(i;u) - "#NAME?".

For me, I have the problem in the "Formula" function, because I can't obtain the right value for the cell that link to the merged cell below. All cycle in the range works correctly for all days of the mouth.

Application.EnableEvents = False

For i = 1 To myRange.Rows.Count
    
    For j = 1 To myRange.Columns.Count
        If myRange.Cells(i, j).MergeCells = True Then
            myRange.Cells(0, 1).Select
        ElseIf IsEmpty(myRange.Cells(i, j)) Then
            myRange.Cells(i, j).Interior.ColorIndex = 3
            myRange.Cells(i, j).Select
            imtRange.Select
            
            myRange.Cells(i, j).Formula = "=ImtRange(Cells(i,u))" '-----> ????
        
        Else
            myRange.Cells(i, j).Interior.ColorIndex = 4
        End If
    Next j
    
    u = u + 1

Next i

Exit Sub

Regard's
FS