Looking to create an excel macro/google apps script (for google sheet) - that will generate a PDF/Excel/Gsheet Purchase Order.
The intent is as follows:
1) There is a spreadsheet with multiple worksheets.
a) Worksheet Products Master - Lists all the products
b) Worksheet Suppliers - Lists all the supplier name and other info
There will be an input page - where a person will go and put in the SKU name and put in the quantity and the script will populate the information from the sheets listed in step a and b and then provide a button to generate a Purchase Order document as a Gsheet/Excel/PDF file
The sheet will be pulling text and images such as product image and upc from links listed in the worksheets (a and b) as part of generating the purchase order