VBA Code to Fill Update Transactions Sheet With Selected Year

[BillySpivy]

Hello,

Is it possible to have code that will fill the Update Transactions sheet from the Transactions sheet with the selected year in cell B3 but do not include columns D and E so that these can be manually entered?

Thank you very much

[Marc L]

According to your attachment a VBA demonstration for starters to paste to the Update Transactions worksheet module :

Sub Demo1() 
    Dim L& 
        L = [N(B3)] 
        Application.ScreenUpdating = False 
    With [B6].ListObject 
        If .ListRows.Count Then .DataBodyRange.Clear 
    With Sheet3.ListObjects(1).Range.Rows 
        .AutoFilter 1, ">=1/1/" & L, xlAnd, "<=12/31/" & L 
         L = Application.Subtotal(103, .Columns(1)) 
         If L > 1 Then .Range("A2:B" & .Count).Copy [B7]: .Range("E2:F" & .Count).Copy [F7] Else Beep: L = 2 
    End With 
        .Resize .Range.Resize(L) 
    End With 
        Application.ScreenUpdating = True 
End Sub  

► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

[BillySpivy]

This code clears columns D and E which I need to input the Categories and Subcategories please.