'copying from Sheet1 to Sheet2 where sheet2 has true blank cells:
For Each cll In Sheets("Sheet2").Range("C3:C15").SpecialCells(xlCellTypeBlanks).Cells
  Sheets("Sheet1").Range(cll.Address).Copy cll
  'or
  'cll.Value = Sheets("Sheet1").Range(cll.Address).Value
Next cll

Sub blah()
Set SourceSht = Workbooks("Book2").Sheets("Sheet1") 'adjust this so that SourceSht is your source sheet.
With SourceSht
  Set RngSource = Range(.Range("C2"), .Cells(.Rows.Count, "C").End(xlUp)) 'this is your source data range; adjust C2 to the top cell of that range.
  'SourceAddress = RngSource.Address(external:=True) 'for the .formula2 version below.
  SourceAddressR1C1 = RngSource.Address(, , xlR1C1, external:=True) 'for the .Formula2R1C1 version below.
End With
With ActiveSheet
  Set DestnCell = .Cells(.Rows.Count, "C").End(xlUp).Offset(1) 'this is the single cell where the formula will go.
  Set RngExisting = .Range(.Range("C3"), DestnCell.Offset(-1)) 'this is your existing data on the active sheet, adjust C3 to the top cell of your data.
  'ExistingAddress = RngExisting.Address 'for the .formula2 version below.
  ExistingAddressR1C1 = RngExisting.Address(, , xlR1C1) 'for the .Formula2R1C1 version below.
End With
  
'choose one of these lines below:
'*********************************
DestnCell.Formula2R1C1 = "=LET(a," & SourceAddressR1C1 & ",FILTER(a,(ISERROR(MATCH(a," & ExistingAddressR1C1 & ",0)))*(a<>"""")))"
'DestnCell.Formula2 = "=LET(a," & SourceAddress & ",FILTER(a,(ISERROR(MATCH(a," & ExistingAddress & ",0)))*(a<>"""")))"
'*********************************
'Convert results to plain values:
If DestnCell.SpillingToRange Is Nothing Then
  If IsError(DestnCell) Then DestnCell.ClearContents Else DestnCell.Value = DestnCell.Value
Else
  DestnCell.SpillingToRange.Value = DestnCell.SpillingToRange.Value
End If
End Sub

Sub blah2()
Set SourceSht = Workbooks("Book2").Sheets("Sheet1") 'adjust this so that SourceSht is your source sheet.
With SourceSht
  RngSource = Range(.Range("C2"), .Cells(.Rows.Count, "C").End(xlUp)).Value 'this is your source data; adjust C2 to the top cell of that range.
End With
With ActiveSheet
  Set DestnCell = .Cells(.Rows.Count, "C").End(xlUp).Offset(1) 'this is the single cell where the results will begin.
  RngExisting = .Range(.Range("C3"), DestnCell.Offset(-1)).Value 'this is your existing data on the active sheet, adjust C3 to the top cell of your data.
End With
For Each v In RngSource
  If Not IsEmpty(v) Then
    If Len(Application.Trim(v)) > 0 Then
      xx = Application.Match(v, RngExisting, 0)
      If IsError(xx) Then
        DestnCell.Value = v
        Set DestnCell = DestnCell.Offset(1)
      End If
    End If
  End If
Next v
End Sub