purchase order

Hi all, I like to experiment in excel to learn new things (as I am still relatively unexperienced), but sometimes I feel I am trying to reinvent the wheel. This is also the case for what I am trying to accomplish right now. See, I want to create an excel template with “fill-in-the-blanks”...

I'm working with a file that has multiple worksheets for different departments that contain Purchase Order information and payments are entered by date moving vertically across the spreadsheet as they are received. I need to be able to easily identify those Purchase Orders that have not...

Hi, I want to create a purchase order generator system in excel, I have created a basic template and got to a stage where I'm stuck for ideas on how to proceed. Basically I want the purchase order to work in a way that, once a supplier is selected from a drop down menu, the product codes...

I'm taking over a spreadsheet made by someone else. The person is not contactable for assistance. I have a table that spans from A4:W514 and is called "CheckbookTable". I need a macro to create a new line in the table, but each new line needs to have a new and unique PO# in column L as well as...

Any help would be greatly appreciated. Some background, I have a purchase order template which after completion needs to be emailed and approved/rejected by a manager. I have written the code for the email but I am also tracking each purchase order and subsequently would like to know whether the...

I'm trying to create a virtual purchase order book that will insert a six digit number that updates each time I open it. I also need to track each purchase order I create (just the purchase order number and the amount) on a master sheet. Can someone help me please?

I am part way through creating a Purchase Order system. I have so far: - One workbook - First worksheet 'Suppliers' is a list of suppliers with all supplier data - Second worksheet 'Template' is the PO template which uses Data Validate to choose supplier details from a drop down list. I want...