Forum Discussion
Create Report Sheet from Datasheet using Excel VBA
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.
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.