Create Report Sheet from Datasheet using Excel VBA

Visitor

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. 

1 Reply

@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.