VBA - filling in blanks in Table column

[JamesonMH]

Hi all,

I have a 6 column running Table (called "CS" - see table below).

Each month my macro takes current data from a separate 5 column table and pastes it to the bottom of the CS table.

After this procedure, there is always the expected blank 1st column in the CS (which is the "File month" header). I need those blank cells in the "File month" column of CS to populate with the value in cell J6 of the current worksheet (which this time around = "April").

File month	DOS	Name	Provider	Amount	Y/N
March	xyz	xyz	xyz	xyz	xyz
March	xyz	xyz	xyz	xyz	xyz
March	xyz	xyz	xyz	xyz	xyz
March	xyz	xyz	xyz	xyz	xyz
Should say April	abc	abc	abc	abc	abc
Should say April	abc	abc	abc	abc	abc
Should say April	abc	abc	abc	abc	abc

<tbody>
</tbody>

I tried variations of the following but no luck. Thanks for your time!

If IsEmpty(Range("CS[[#Headers],[File month]]").Value) = True Then
ActiveWorkbook.Worksheets("Helper Tbls").Range ("J6")
End If

James