Creating a master calendar that automatically updates sub-calendars

Hi there

I am learning excel vba for a work project. The goal is to have a master holiday calendar that automatically updates the cells in each individual calendar with each holiday (i.e. meaning if I wanted to change the dates of certain holidays, I would only need to do so on the master calendar, and then it would automatically update each employee's individual holiday calendar).

Currently, this is what I could manage to come up with: looking for cells marked "v" (holidays) and then copying those cells to the next worksheet.

With Sheets("Mastersheet").Range("B11:AM94")
Set c = .Find("v", LookIn:=xlValues)
If Not c Is Nothing Then
firstaddress = c.Address
Do
c.Copy Worksheets("Practice1").Range(c.Address)
Set c = .FindNext(c)
If c Is Nothing Then
GoTo DoneFinding
End If
Loop While Not c Is Nothing And c.Address <> firstaddress
End If
DoneFinding:
End With
End Sub


But for some reason it stops around November and says "Run time error 1004: We cant do that to a merged cell"



I am not very familiar with VBA at all, so any comments/thoughts would be much appreciated! Thank you all in advance!