ExcelBanter - Creating a Purchase Order

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Creating a Purchase Order (https://www.excelbanter.com/excel-worksheet-functions/136158-creating-purchase-order.html)

Creating a Purchase Order

Im am trying to create a purchase order for the sales guys in my office to
use. I want them to be able to have the purchase order on there desk tops
and be able to add in the "company name" in the "compnay name" feild without
changing or the verbiage in the field. Example: COMPANY NAME: (the sales
guy add the company name here" with out changing the verbiage "COMPANY
NAME".
--
confused

Creating a Purchase Order

You can't without using VBA.

Why not put "COMPANY NAME:" in A2 and enter the name in B2?

If a new "form" i.e. template, is used for each PO then B2 could contain
text "Enter company here" and would be overwritten by the data entry.

HTH

"Maddie" wrote:

Im am trying to create a purchase order for the sales guys in my office to
use. I want them to be able to have the purchase order on there desk tops
and be able to add in the "company name" in the "compnay name" feild without
changing or the verbiage in the field. Example: COMPANY NAME: (the sales
guy add the company name here" with out changing the verbiage "COMPANY
NAME".
--
confused