Forum Discussion
ashfaqahmed947
Feb 05, 2021Copper Contributor
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.
1 Reply
- NikolinoDEPlatinum Contributor
Private Sub Workbook_BeforePrint(Cancel As Boolean) Worksheets("Quittung").Range("B1") = Worksheets("Quittung").Range("B1") + 1 End SubPlease, 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.