Purchase Order form and tracker

[JBeeNC]

Hi all, I am new to the group so forgive any errors please. I am somewhat versed with Excel. I used the create Invoice and tracker template which I modified to a Purchase Order. I created a dropdown list on the PO form that the user can select to fill out a PO, cell is G4. The numbers are in a table in a sheet called TRACKER. The PO is a sheet called PO. I need the PO to change with each new number selected. The previous numbers need to save and lock so the number can't be reselected and modified. That information needs to feed into the table I linked as TRACKER. I can provide the file to show what I have done so far. I was unable to upload it here as the file type is not supported. Any assistance would be much appreciated! TYIA

 

[sijpie]

This is fairly common use. If you upload the tracker sheet in dropbox or similar and put the link here, I can have a look

 

[JBeeNC]

This is fairly common use. If you upload the tracker sheet in dropbox or similar and put the link here, I can have a look

Thank you for the reply. I have attached images below. I need the form to feed to the tracker worksheet then close when submitted and go to the next PO number and so on. Please let me know if you need any more information. I appreciate your assistance.

 

[sijpie]

In order that i won't need to create a lot of code for nothing, can you please upload a clean copy of your workbook in dropbox or similar and post the link?

 

[JBeeNC]

Hi Sijpie, I am unable to upload the file. It does not have an approved extension. I have done some coding to calculate the total in total box on the form and tried to code it so that the subtotal is automatically calculated as well. Do I need to change the file type in order to be able to upload? Just let me know.

 

[sijpie]

I know you can't upload it on this board, but there are lots of sharing sites like dropbox or sync.com, google drive or any other

 

[JBeeNC]

Hi Sijpie, please try this link to G Drive. Thank you!
https://drive.google.com/file/d/0B_ZwvxbNpGcMR0d4Sy1NSGNYekxXTEhlOTZWclNqay1UbC1N/view?usp=drivesdk

 

[sijpie]

Great. I'll get to work with this

 

[sijpie]

Hi JBeeNC,

I've just found the email to this forumpost in my inbox, and notice that I promised to have a look. Do you still need this? Let me know.