Copy value of merged cell to another cell.

[Francisco Sousa]

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.

Please Login or Register  to view this content.

Regard's
FS

[gmr4evr1]

In G13

Please Login or Register  to view this content.

Edit*I think I might be wrong, but I left it here just in case.