Excel Enthusiast
Member
I took help from this link to automate the Purchase Order Sr.No, and for saving the file in a unique name and to clears cells on the worksheet so i can start fresh on the next invoice. https://www.microsoft.com/en-us/microsoft-365/blog/2012/01/12/generate-invoice-numbers-in-excel/ .
I have assigned the Macros to different buttons but it is not working. Please, tell me, what i'm doing wrong.
As mentioned earlier i would like to tell everyone that i'm a novice and don't know anything about macros.
please help & oblige.
I'm attaching the PO File, 1st Sheet named "PO" protection password is 123.
Thank You.
I have assigned the Macros to different buttons but it is not working. Please, tell me, what i'm doing wrong.
As mentioned earlier i would like to tell everyone that i'm a novice and don't know anything about macros.
please help & oblige.
I'm attaching the PO File, 1st Sheet named "PO" protection password is 123.
Thank You.