Create Report Sheet from Datasheet using Excel VBA

[ashfaqahmed947]

Dear Community members,

In need some help for creating report sheet using Excel VBA with Bill No. Field. Sample Sheet("Report") is attached for reference. 

[#2]

@ashfaqahmed947 

Private Sub Workbook_BeforePrint(Cancel As Boolean)
    Worksheets("Quittung").Range("B1") = Worksheets("Quittung").Range("B1") + 1
End Sub

 Please, adjust settings, path and name.

I would be happy to know if I could help.

I wish you continued success with Excel

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.