I have a PO form that I have created in Excel. It is set up as a template, and I would like to have a macro assign a sequentional number to the PO's as they are written. Does anyone know how to help me with this?
Thank you,
Tracy
Tracy62 0 Newbie Poster
cguan_77 8 Nearly a Posting Virtuoso
possible to attached your PO form? Just put dummy data on it.. :)
Tracy62 0 Newbie Poster
When I try to upload it says invalid file? Can I email it to you?
cguan_77 8 Nearly a Posting Virtuoso
uploading of excel file here in daniweb shoudln't be a problem...tried it a couple of times..can try again? what's the error when you upload?
Tracy62 0 Newbie Poster
uploading of excel file here in daniweb shoudln't be a problem...tried it a couple of times..can try again? what's the error when you upload?
Close this window Manage Attachments
Upload Errors
PO Template.xltm:
Invalid File
Upload File from your Computer
Upload File from a URL
This is the error message I get when I try to upload it.
cguan_77 8 Nearly a Posting Virtuoso
try to put the file to a zip file, right click the file on windows explorer and use send to zip to convert the file to a zip file..then upload it here.. :)
Tracy62 0 Newbie Poster
try to put the file to a zip file, right click the file on windows explorer and use send to zip to convert the file to a zip file..then upload it here.. :)
Ok, here is the file...This is our PO template, I would like the template to open with a number, and then the next time it opens, open with the next number....say we start with 150001,150002, etc...
I hope you can help!!
Thanks for being patient!
Tracy
cguan_77 8 Nearly a Posting Virtuoso
Hi tracy62, click on your company logo and the invoice number will automatically changed to the next PO number, hope that's what you want :)
Tracy62 0 Newbie Poster
Hi tracy62, click on your company logo and the invoice number will automatically changed to the next PO number, hope that's what you want :)
This will work, but I need to know how to make my starting # different, we have many supervisors, and they each have there own set of numbers...ex.. 12000, 13000, 14000...etc
I really appreciate your help!!
Thanks
Tracy
cguan_77 8 Nearly a Posting Virtuoso
you mean different supervisors will have different PO number or what?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.