VBA Help. Transfer sum to another sheet (LOG)

Unfortunately I cannot do that. I am working out of a work account of Excel.

I guess I will have to scrap this project, I haven't been able to figure it out. I am certain it should be a pastespecial xlpastevalues but I can't get that to work.

Best I can do is paste the VBA. My Excel is 365 and belongs to the department--not savvy enough to know if its safe to share

'Create and set variables for each cell in the FC80 sheet
Dim VENDORNAME As Range, ORDERDATE As Range, PREPARER As Range, SUBTOTAL As Range
Dim total As Range, SVCLOC As Range, LOGNO As Range

Set CAMPDOC = FC80.Range("A20")
Set VENDORNAME = FC80.Range("C12")
Set ORDERDATE = FC80.Range("G13")
Set PREPARER = FC80.Range("C9")
Set SUBTOTAL = FC80.Range("J34")
Set total = FC80.Range("J36")
Set SVCLOC = FC80.Range("D42")


'Create a variable for the paste cell in the FC80 Log worksheet
Dim DestCell As Range

If FC80LOG.Range("A2") = "" Then 'If A2 is empty
Set DestCell = FC80LOG.Range("A2") '...then destination cell is A2
Else
Set DestCell = FC80LOG.Range("A1").End(xlDown).Offset(1, 0) '...otherwise the next empty row
End If

'If no "VENDOR called has been entered, exit macro
If VENDORNAME = "" Then
MsgBox "You must enter a VENDOR NAME before adding to the log"
Exit Sub
End If



'Copy and paste data from the FC80 worksheet to the FC80 Log worksheet

CAMPDOC.Copy DestCell
VENDORNAME.Copy DestCell.Offset(0, 1)
ORDERDATE.Copy DestCell.Offset(0, 2)
PREPARER.Copy DestCell.Offset(0, 3)
SUBTOTAL.Copy DestCell.Offset(0, 4)
total.Copy DestCell.Offset(0, 5)
SVCLOC.Copy DestCell.Offset(0, 6)


End Sub