Need to auto increment and update PO # and save file as cells H7,J7, and A14

Hi carson

Try the code in the attached...let me know of issues.

Originally Posted by jaslake

Hi carson

Try the code in the attached...let me know of issues.

Hey, the post button works great thank you, but how do I get the save as function to work? so the file is saved as the po # and then vendor name? so the next person that issues a PO will have the next incremental PO # and a blank worksheet to use?

Sorry I found out the post button does that. This will be used on a shared server environment so how can we get it so the next person that issues a PO will have the next incremental PO # and a blank worksheet to use?

Thanks Again

Hi carson

The "Post" button does this

the save as function to work

and this

the next person that issues a PO will have the next incremental PO #

It DOES NOT do this

a blank worksheet to use

What cells do you wish cleared?

Attachment 185348
J10 job #
J11 unit#
A14 vendor info
H14 - H19 ship to info
A22 shipping date
D22 shipping via
H22 FOB point
L22 terms
A25 - K38 Qty, item#, description, and unit price
M40 sales tax
M41 shipping
I47 signature line


Can we also get the file to save as a PDF

Hi carson

Are you planning to use Data Validation to pull info into the Form (eg: Vendor Name, Job #, Shipping Terms, Signature Line, etc)?

You've a lot of unfinished business that's not been defined.

Your Thread defines this as the issue

I am in need of VBA code or macros to auto increment and update my PO # and save file as cells H7,J7, and A14

I believe the code does just that.

Please define further what you need to happen...perhaps one of us can help.

Hi carson

This code is in the attached...let me know of issues.

Please Login or Register  to view this content.