Error with Data Dump Macro

Try this. I think your code can be shortened and simplified a little and I have taken the liberty.

Option Explicit

Sub Dynamic_Table()
    
Dim RowC, Colc As Integer
Dim CRow, CCol As Integer
Dim i As Integer
Dim SupName As String

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

'Delete the Data from "Data for Pivot"

With Sheets("Data for Pivot")
    .Range("A3", .Range("A3").End(xlDown)).Clear
    .Range("A3", .Range("A3").End(xlDown)).NumberFormat = "dd/mm/yyyy hh:mm"
End With

' Dynamically count Data in BBG Raw Data sheet

With Sheets("BBG Raw Data")
    .Range("A4", .Range("A4").End(xlDown)).Copy
    Sheets("Data for Pivot").Range("A3").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Application.CutCopyMode = False
End With

Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic

End Sub

Wow, thanks so much Stephen! It works perfectly now. What was the reason it wasn't capturing the last two data points? Also, when I hit update, the worksheet runs much quicker; did the code you put in have anything to do with this?

Thanks again,

Maani

Glad it worked.

In your code you were counting the number of non-empty cells but not allowing for blank cells at the top.

The turning off of screen updating and calculation speeds up code. Removing Select statements, which tend to be thrown up the macro recorder, has a similar effect.