Share via

Creating A Purchase order Form in Excel

Anonymous
2010-10-30T23:31:36+00:00

Need a form that users can input data only in the fields that change on each Purchase Order (and one of the fields needs to have a forumula to calculate unit price.) Need the PO form data to be able to link to a worksheet that collects data from each PO for total units/vendors/revenue/sales, etc.

Thank you

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2010-10-31T14:06:41+00:00

    You could try Excel's Data Form. Say you have the column Headings

    Date, PO#, Item, Description, Qty, Price, Cost

    Price is a calculated field and the column Headings are bold; choose Data, Form. Excel launches a simple form that can be used to enter, delete and search for records. Each record is added to the data sheet when you click OK. Calculated fields are greyed out in the form but the formula is entered in the worksheet with the rest of the data.

    The only problem is that you have to reenter the Data, and date for each item on the order.

    If you want the form actually in the worksheet you have to create a macro to copy each line of data into PO Record sheet. The advantage is that you can use lookup formulas to to get the Item description and only the numerical data needs to be copying. In this way, Excel behaves more like a database.

    If this is what you need I'll send you one I did ages ago.

    peter_atherton AT hotmail.com

    Regards

    Peter

    10+ people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-05-30T06:00:58+00:00

    The link which u suggest is not showing the template its just displaying the empty page.

    if possible can u please send the url again.

     Regards

    Pradhyu

    0 comments
  2. Anonymous
    2014-09-11T15:23:46+00:00

    please send me the form at ******@att.net thanks

    0 comments
  3. Anonymous
    2010-10-31T00:04:01+00:00

    Thanks I downloaded a PO; however, I'm trying to take a form such as that put only tab to the blank fields I need and then also have the PO# and other data to be on a worksheet.  Currently we have to enter the info twice once for the PO in excel and then  create an excel file with all the PO#s, supplier, cost, etc.  thought I could somehow create a data form that would end up looking the this PO template and also make a report with the data.  Hope you understand my question or dilemma.

    0 comments
  4. Anonymous
    2010-10-30T23:46:45+00:00
    0 comments