There is already a "Purchase Order" excel Template worksheet. There are 4-5 people using this document in one office, and they have a shared server where all purchase orders are stored inside a folder that is shared by everyone.
Requirements: Whenever someone opens this Purchase Order document and completes it..created a button on the page that will automatically assign a PO# (auto-generated) in sequential order from previous Purchase Order#. (For example. if first PO# is 100, next one that is saved should be 101, next one should be 102, etc.). Also, when clicking this button, it will automatically save the Purchase Order in a specific folder on the server, with naming convention example, PO# 100, PO# 101, PO# 102, etc.
Does someone have a code that they can send me? I assume its fairly easy.
Thank you-
Requirements: Whenever someone opens this Purchase Order document and completes it..created a button on the page that will automatically assign a PO# (auto-generated) in sequential order from previous Purchase Order#. (For example. if first PO# is 100, next one that is saved should be 101, next one should be 102, etc.). Also, when clicking this button, it will automatically save the Purchase Order in a specific folder on the server, with naming convention example, PO# 100, PO# 101, PO# 102, etc.
Does someone have a code that they can send me? I assume its fairly easy.
Thank you-
