Macro help for compiling data to randomly blank cells

Would I be able to maniplulate this code to do what im looking for? Say if theres a blank cell, paste that corresponding value?

ActiveWorkbook.Close SaveChanges:=True
    Set wbk = Workbooks.Open(strFirstFile)
    With wbk.Sheets("Sheet1")
        .Range("A1:A500").Copy
    End With
    Set wbk = Workbooks.Open(strSecondFile)
    With wbk.Sheets("Sheet1")
        .Range("C1:C500").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:= _
            False, Transpose:=False
    End With

Bump...Anyone?

Would it be possible to do something like a "SkipValue" command like the SkipBlanks command?

Bump it up.

bump. still looking for a solution

Still need a solution to this issue