Hi all and hope you can help.
I am trying to create an order template with the following headings
ITEM - CATEGORY - COST - DISCOUNT - %
I have a data sheet with the entire product(ITEM, CATEGORY, COST) list on sheet 2. I have also created a drop-down list with the ITEM name from the data sheet.
My question is... when i selct an item from the drop down list. Can i create a button that adds the row from the data sheet to the client order populating ITEM, CATEGORY and COST?
Thank you,
Bookmarks